SQL方言参考: 5. 大型对象类型

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	CLOB	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	BLOB	BLOB SUB_TYPE BINARY	BLOB LONG BYTE	BLOB	varbinary(max) image	BLOB BINARY LARGE OBJECT	BLOB	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	?

Last modified: Friday, 11 April 2025, 9:56 AM