Ispirer Ispirer
 


Ispirer Home Page Ispirer SQLWays Product Page - Informix Migration Request SQLWays

Informix Dynamic Server (IDS) Data Types - SMALLINT

Versions: Informix Dynamic Server 11.x, 10.x, 9.x and 7.x

Informix - SMALLINT
Syntax SMALLINT
Data 16-bit integer data
Range -32768 to 32767
Storage Size 2 bytes
Standards ANSI SQL

Example:

CREATE TABLE t_smallint (c1 SMALLINT);

Informix SMALLINT - Equivalents in Other Databases

Database Data Type and Conversion
Oracle NUMBER(5,0), -105-1 to 105-1
SQL Server SMALLINT, -32768 to 32767
MySQL SMALLINT, Signed: -32768 to 32767, Unsigned: 0 to 65535
PostgreSQL SMALLINT, -32768 to 32767
Sybase ASE SMALLINT, Signed: -32768 to 32767, Unsigned: 0 to 65535
HP Neoview SMALLINT, Signed: -32768 to 32767, Unsigned: 0 to 65535
Ingres SMALLINT, -32768 to 32767; TINYINT, -128 to 127

Related Data Types in Informix

Data Types
Integers BIGINT INT
Auto-increment integers BIGSERIAL SERIAL
Fixed-point DECIMAL(p,s) NUMERIC(p,s)
Floating-point FLOAT(p) REAL, SMALLFLOAT DOUBLE PRECISION

All Data Types


Ispirer Home Page Ispirer SQLWays Product Page - Informix Migration Request SQLWays

sqlways/informix/data-types/smallint.txt · Last modified: May 07, 2018, 03:15:26 PM (external edit)
 
© 1999-2021, Ispirer Systems Ltd.
All Rights Reserved.  Privacy Statement