Ispirer Ispirer
[Sybase ASE Data Types - INT]
 
You are here: » Ispirer Migration Knowledge Base » Sybase Database » Sybase ASE Data Types » Sybase ASE Data Types - INT


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

Sybase ASE Data Types - INT

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

Sybase ASE - INT
Syntax [UNSIGNED] INT
Data 32-bit integer data
Range Signed: -231 to 231-1 (2G), Unsigned: 0 to 232-1 (4G)
Storage Size 4 bytes
Synonyms INTEGER
Standards INT - ANSI SQL, UNSIGNED INT - Sybase Transact-SQL Extension

Sybase ASE INT - Equivalents in Other Databases

Database Data Type and Conversion
Oracle NUMBER(10,0), -1010-1 to 1010-1
SQL Server INT, -231 to 231-1 (2G)
MySQL INT, Signed: -231 to 231-1 (2G), Unsigned: 0 to 232-1 (4G)
PostgreSQL INT, -231 to 231-1 (2G)
Informix INT, -231 to 231-1 (2G)
HP Neoview INT, Signed: -231 to 231-1 (2G), Unsigned: 0 to 232-1 (4G)
Ingres INTEGER, -231 to 231-1

Related Data Types in Sybase ASE

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

All Data Types

Oracle SQL Server IBM DB2 MySQL PostgreSQL Sybase ASE Sybase ASA Informix DS Teradata HP Neoview Interbase/Firebird Ingres


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

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