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 |
| 