Ispirer Website Ispirer Capabilities - Ingress Migration Free Trial

Ingres Data Types - SMALLINT

Versions: Ingres 9.x and 10.0

Ingres - SMALLINT
Syntax SMALLINT
Data 16-bit integer data
Range -32768 to 32767
Storage Size 2 bytes
Synonyms INTEGER2, I2
Standards ANSI SQL

Ingres 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
Informix SMALLINT, -32768 to 32767
HP Neoview SMALLINT, Signed: -32768 to 32767, Unsigned: 0 to 65535

Related Data Types in Ingres

Data Types
Integers BIGINT INTEGER TINYINT
Fixed-point DECIMAL(p,s) NUMERIC(p,s)
Floating-point FLOAT REAL

All Data Types


© 1999-2024, Ispirer Systems, LLC. All Rights Reserved.