Ispirer Home Page Ispirer SQLWays Product Page - Migration to Sybase Request SQLWays

Sybase ASE Data Types - SMALLINT

Versions: Sybase Adaptive Server Enterprise 15.x, 12.5.x, 12.0 and 11.x

Sybase ASE - SMALLINT
Syntax [UNSIGNED] SMALLINT
Data 16-bit integer data
Range Signed: -32,768 to 32,767, Unsigned: 0 to 65535
Storage Size 2 bytes
Standards SMALLINT - ANSI SQL, UNSIGNED SMALLINT - Sybase Transact-SQL Extension

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

Related Data Types in Sybase ASE

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

All Data Types


Ispirer Home Page Ispirer SQLWays Product Page - Migration to Sybase Request SQLWays


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