SQL Dialects Reference/Data structure definition/Data types/Large object types
From Wikibooks, the open-content textbooks collection
[edit] Large object types
| Feature | DB2 | Firebird | Ingres | MSSQL | MySQL | Oracle | PostgreSQL | SQLite | Virtuoso | Linter |
|---|---|---|---|---|---|---|---|---|---|---|
| Character LOBs | CLOB(n) | BLOB SUB_TYPE 1 | CLOB, TEXT, LONG VARCHAR |
TEXT / NTEXT VARCHAR(MAX) / NVARCHAR(MAX) [1] |
TEXT | CLOB | TEXT | TEXT | LONG VARCHAR | BLOB |
| Binary LOBs | BLOB(n) | BLOB SUB_TYPE 0 | BLOB, LONG BYTE |
IMAGE VARBINARY(MAX) |
BLOB(n) | BLOB | BYTEA, lo | BLOB(n) | LONG VARBINARY | BLOB |
Notes:
- ↑ The VARCHAR(MAX) / NVARCHAR(MAX) / VARBINARY(MAX) data types are introduced in SQL Server 2005 and allow texts up to 2GB without the programming limitations of the TEXT / NTEXT / IMAGE data types