CLOB: Column Types
CLOB is an acronym for Character Large Object.
| Database | Data Type | Notes |
|---|---|---|
| Access 2000 | TEXT | |
| DB2 8.1 | CLOB | |
| Firebird 1.5 | BLOB | |
| FrontBase 4.1 | CLOB | Have to use special routines for inserting data. |
| MySQL 4.0 – 4.1 | TEXT | |
| Oracle 9.2 | CLOB | |
| PostgreSQL 7.4 | TEXT | |
| SQL Server 2000 | TEXT | |
| SQLite 2.8 | CLOB | |
| Sybase ASE 12.5 | TEXT |