ASE supports three new datatypes:
bigint – an exact numeric datatype designed to be used when the range of the existing int types is insufficient.
unsigned int – unsigned versions of the following signed exact numeric integer datatypes: unsignedsmallint, unsignedint, and unsignedbigint.
unitext – a variable-length datatype for Unicode characters.
The following table describes all new datatypes supported by ASE, SDK Data Providers, and Drivers:
ASE datatype |
Stores data which is |
Size in bytes |
---|---|---|
bigint |
Whole numbers between -263 and 263 - 1 (-9,223,372,036,854,775,808 and +9,223,372,036,854,775,807) |
8 |
unsignedsmallint |
0 and 65535 |
2 |
unsignedint |
0 and 4,294,967,295 |
4 |
unsignedbigint |
0 and 18,446,744,073,709,551,61) |
8 |
unitext |
Unicode characters up to 30 - 1 characters in length (1,073,741,823) |
231 -1 (2,147,483,646) |
For more information on the new ASE datatypes, see these documents:
Adaptive Server Enterprise ODBC Driver by Sybase User’s Guide for your platform
Adaptive Server Enterprise OLE DB Provider by Sybase User’s Guide for Microsoft Windows
Adaptive Server Enterprise ADO.NET Data Provider User’s Guide