Ispirer Website Ispirer Capabilities - Sybase Migration Free Trial

Sybase ASE Data Types - TEXT

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

Sybase ASE - TEXT
Syntax TEXT
Data Variable-length character data
Range 231-1 bytes (2G)
Storage Size 0 bytes when empty, otherwise multiple of 2K
Internals Data is stored in data pages that are separate from the rest of the table
Standards Sybase Transact-SQL Extension

Sybase ASE TEXT - Equivalents in Other Databases

Database Data Type and Conversion
Oracle CLOB, 4G
SQL Server VARCHAR(n | max), 1 ⇐ n ⇐ 8000, 2G if max is specified, TEXT, 2G
MySQL LONGTEXT, 4G
PostgreSQL TEXT, 1G
Informix TEXT, 2G, CLOB, 4T
HP Neoview VARCHAR(n), 1 ⇐ n ⇐ (32708 - size of other columns)
Ingres TEXT(n), 1 ⇐ n ⇐ 32000; LONG VARCHAR, 2G

Related Data Types in Sybase ASE

Data Types
Fixed-length character data CHAR(n) NCHAR(n) UNICHAR(n)
Variable-length character data VARCHAR(n) NVARCHAR(n) UNIVARCHAR(n)
Character large objects UNITEXT

All Data Types


© 1999-2024, Ispirer Systems, LLC. All Rights Reserved.