SQL方言参考
完成条件
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