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