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 ? ? 231−1 216 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 ? ? 231−1 216 about 2 GB 4 GB - 1 byte ? 1 000 000 000 ?

最后修改: 2025年04月11日 星期五 09:56