Google
Web tarasdom.com

 

Sybase types

See also Sybase tips page

Sybase types
Type Values Storage (bytes)
Simple numeric
tinyint 0..255 1
smallint -32768..32767 2
int -2147483648..2147483647 4
bit 0..1 1 (max 8 columns, could not be NULL)
Numeric
numeric[(precision[,scale])] -1038..1038-1 2..17 (precision+scale<=38)
decimal[(precision[,scale])] -1038..1038-1 2..17
Money
money numeric(19,4) 8
smallmoney numeric(10,4) 4
Float
float[(precision)] floating numbers platform-dependent,precision<=48
real floating numbers platform-dependent
double precision] floating numbers platform-dependent
Date & time
datetime 01-Jan-1753..31-Dec-9999 8(precision=3 millisec)
smalldatetime 01-Jan-1900..06-Jun-2079 4(precision=1 millisec)
date 01-Jan-0001..31-Dec-9999 4(from ver.12.5.1)
time 00:00:00..23:59:59.999 4(from ver.12.5.1,precision=3 millisec)
Character
char(n) character value n(for pre-12.5: n<=255)
varchar(n) character value 1..n(from 12.5: n<=16296)
nchar(n) character value n*@@ncharsize
nvarchar(n) character value 1..n*@@ncharsize
Binary
binary(n) binary value n(for pre-12.5: n<=255)
varbinary(n) binary value 1..n(from 12.5: n<=16296)
Unicode
unichar(n) Unicode value n*@@unicharsize (from 12.5)
univarchar(n) Unicode value 1..n*@@unicharsize (from 12.5)
Text & Image
text character value <=2 Gb
image binary value <=2 Gb

©
Page was modified 20.06.2006