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

From Wikibooks, open books for an open world
< SQL Dialects Reference
Jump to: navigation, search

Large object types[edit]

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: