User Documentation
Ispirer Capabilities - Sybase Migration
Pricing
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