Ispirer Ispirer
 


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

Sybase ASE Data Types

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

Data Type Parameters and Range
Character Data Types
CHAR(n) - Fixed-length character data 1 ⇐ n ⇐ pagesize (2K, 4K, 8K or 16K), default is 1
NCHAR(n) - Fixed-length character data 1 ⇐ n ⇐ pagesize/@@ncharsize, default is 1
UNICHAR(n) - Fixed-length character data in Unicode 1 ⇐ n ⇐ pagesize/@@unicharsize, default is 1
VARCHAR(n) - Variable-length character data 1 ⇐ n ⇐ pagesize, default is 1
NVARCHAR(n) - Variable-length character data 1 ⇐ n ⇐ pagesize/@@ncharsize, default is 1
UNIVARCHAR(n) - Variable-length character data in Unicode 1 ⇐ n ⇐ pagesize/@@unicharsize, default is 1
TEXT - Variable-length character data 2G
UNITEXT - Variable-length character data 2G
Integer Data Types
BIGINT - 64-bit integer data Signed: -263 to 263-1, Unsigned: 0 to 264-1
INT, INTEGER - 32-bit integer data Signed: -231 to 231-1 (2G), Unsigned: 0 to 232-1 (4G)
SMALLINT - 16-bit integer data Signed: -32768 to 32767, Unsigned: 0 to 65535
TINYINT - 8-bit integer data 0 to 255
Decimal Data Types
NUMERIC(p,s), DECIMAL(p,s) - Fixed-point numeric data -1038 to 1038-1; 1 ⇐ p ⇐ 38, default is 18; 0 ⇐ s ⇐ p, default is 0
Floating-Point Data Types
FLOAT(p) - Floating-point numeric data Machine dependent
REAL - 32-bit floating-point numeric data Machine dependent
DOUBLE PRECISION - 64-bit floating-point numeric data Machine dependent
Date and Time Data Types
DATE - Date data (year, month and day) January 01, 0001 to December 31, 9999
TIME - Time data (hours, minutes, seconds and milliseconds) 00:00:00.000 to 23:59:59.999
DATETIME - Date and time data (year, month, day, hours, minutes, seconds and 1/300 seconds) January 01, 1753 00:00:00.000 to December 31, 9999 23:59:59.997
SMALLDATETIME - Date and time data (year, month, day, hours and minutes) January 01, 1900 00:00 to June 06, 2079 23:59
Binary Data Types
BINARY(n) - Fixed-length binary data 1 ⇐ n ⇐ pagesize (2K, 4K, 8K or 16K), default is 1
VARBINARY(n) - Variable-length binary data 1 ⇐ n ⇐ pagesize, default is 1
IMAGE - Variable-length binary data 2G
Other Data Types
BIT - Boolean data 0 and 1 only (NULL is not allowed)
MONEY - Monetary data -922,337,203,685,477.5808 to 922,337,203,685,477.5807
SMALLMONEY - Monetary data -214,748.3648 to 214,748.3647
TIMESTAMP - Auto-updated binary data

Data Types in Other Databases


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

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