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

Large object types[edit | edit source]

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:

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

Large object types[edit | edit source]

Navigation menu

Search