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

Sybase ASE Data Types - BIGINT

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

Sybase ASE - BIGINT
Syntax [UNSIGNED] BIGINT
Data 64-bit integer data
Range Signed: -263 to 263-1, Unsigned: 0 to 264-1
Storage Size 8 bytes
Standards BIGINT - ANSI SQL, UNSIGNED BIGINT - Sybase Transact-SQL Extension

Sybase ASE BIGINT - Equivalents in Other Databases

Database Data Type and Conversion
Oracle NUMBER(19,0), -1019-1 to 1019-1
SQL Server BIGINT, -263 to 263-1
MySQL BIGINT, Signed: -263 to 263-1, Unsigned: 0 to 264-1
PostgreSQL BIGINT, -263 to 263-1
Informix BIGINT, -263 to 263-1
HP Neoview LARGEINT, -263 to 263-1
Ingres BIGINT, -263 to 263-1

Related Data Types in Sybase ASE

Data Types
Integers INT SMALLINT 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.