SQL Dialects Reference/Data structure definition/Data types/Large object types

Large object typesEdit

This page includes comparison tables which can be big and complex.

While it's perfectly all right to view them in their complete state, it is recommended to install a comparison tables extension that would allow to select particular columns of interest for comparison.

SQL version Feature Standard
SQL:2011
DB2 Firebird Ingres Linter MSSQL MySQL
Vers. 5.x
MonetDB Oracle
Vers. 11.x
PostgreSQL SQLite Virtuoso
 ? Character LOBs CLOB(n) CLOB(n) BLOB SUB_TYPE TEXT CLOB,
TEXT,
LONG VARCHAR
BLOB varchar(max)
nvarchar(max)
text
ntext
TEXT STRING,
CLOB,
TEXT,
CHARACTER LARGE OBJECT
CLOB text TEXT LONG VARCHAR
 ? Character LOBs max size, bytes no limit  ? about 4 GB  ?  ? 2^{31}-1 2^{16}  ?  ? about 1 GB 1 000 000 000  ?
 ? Binary LOBs BLOB(n) BLOB(n) BLOB SUB_TYPE BINARY BLOB
LONG BYTE
BLOB varbinary(max)
image
BLOB(n)
BINARY LARGE OBJECT
BLOB(n) BLOB bytea
lo
BLOB(n) LONG VARBINARY
 ? Binary LOBs max size, bytes no limit  ? about 4 GB  ?  ? 2^{31}-1 2^{16}  ?  ?  ? 1 000 000 000  ?

Notes:

Last modified on 17 March 2014, at 19:57