User Documentation
Ispirer Capabilities - Microsoft SQL Server Migration
Pricing
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