SQL Dialects Reference/Data structure definition/Data types/Misc types
From Wikibooks, the open-content textbooks collection
[edit] Misc 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.
| Feature | DB2 | Firebird | Ingres | MSSQL | MySQL | Oracle | PostgreSQL | SQLite | Virtuoso | Linter |
|---|---|---|---|---|---|---|---|---|---|---|
| Boolean | N/A | N/A | BIT | BOOLEAN, BOOL | BOOLEAN | BIT | BOOLEAN | |||
| UUID | N/A | UNIQUEIDENTIFIER | N/A | IRI | ||||||
| Row version | TIMESTAMP / ROWVERSION | |||||||||
| XML | XML | |||||||||
| Any data type | SQL_VARIANT |
