Ispirer Website Ispirer Capabilities - Microsoft SQL Server Migration Free Trial

SQL Server Data Types - TEXT

Versions: SQL Server 2008, 2005, 2000, 7.0 and 6.5

SQL Server - TEXT
Syntax TEXT
Data Variable-length character data (character large object), single-byte and multibyte character sets
Range 2G
Notes TEXT data type will be removed in future versions of SQL Server, it is recommended to use VARCHAR(max)
Standards SQL Server Extension

SQL Server TEXT - Equivalents in Other Databases

Database Data Type and Conversion
Oracle CLOB, 4G
MySQL LONGTEXT, 4G
PostgreSQL VARCHAR(n), 1 ⇐ n ⇐ 1G TEXT, 1G
Sybase ASE TEXT, 2G
Informix TEXT, 2G CLOB, 4T
HP Neoview VARCHAR(n), 1 ⇐ n ⇐ (32708 - size of other columns)
Ingres LONG VARCHAR, 2G

Related Data Types in SQL Server

Data Types
Fixed-length Character Data CHAR(n) NCHAR(n)
Variable-length Character Data VARCHAR(n) NVARCHAR(n)
Character Large Objects NTEXT

All Data Types


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