Help
Add this page to your collection
Show collection (0 pages)
Suggest pagesSQL Dialects Reference/Data structure definition/Data types/Large object types
From Wikibooks, open books for an open world
This page may need to be [edit] Large object types
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 | DB2 | Firebird | Ingres | Linter | MSSQL | MySQL | Oracle | PostgreSQL | SQLite | Virtuoso |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ? | Character LOBs | ? | CLOB(n) | BLOB SUB_TYPE 1 | CLOB, TEXT, LONG VARCHAR |
BLOB | varchar(max) nvarchar(max) text ntext |
TEXT | CLOB | text | TEXT | LONG VARCHAR |
| ? | Character LOBs max size, bytes | ? | ? | ? | ? | ? | 231 − 1 | 216 | ? | about 1 GB | 1 000 000 000 | ? |
| ? | Binary LOBs | ? | BLOB(n) | BLOB SUB_TYPE 0 | BLOB LONG BYTE |
BLOB | varbinary(max) image |
BLOB(n) | BLOB | bytea lo |
BLOB(n) | LONG VARBINARY |
| ? | Binary LOBs max size, bytes | ? | ? | ? | ? | ? | 231 − 1 | 216 | ? | ? | 1 000 000 000 | ? |
Notes:
