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

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 2 GB	4 GB - 1 byte	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	LONG VARBINARY
?	Binary LOBs max size, bytes	no limit	?	about 4 GB	?	?	$2^{31}-1$	$2^{16}$	about 2 GB	4 GB - 1 byte	?	1 000 000 000	?

Notes: