Last modified on 27 February 2015, at 12:21

SQL Dialects Reference/Data structure definition/Data types/Misc types

Misc typesEdit

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
SQL:2011
DB2 Firebird Ingres Linter MSSQL MySQL
Vers. 5.x
MonetDB Oracle
Vers. 11.x
PostgreSQL SQLite Virtuoso
 ? Boolean boolean N/A N/A  ? BOOLEAN BIT BOOLEAN
TINYINT(1)
BOOLEAN No BOOLEAN  ? BIT
 ? Boolean storage size N/A  ?  ?  ?  ? 8 columns in a single table = 1 byte 1 byte 1 byte N/A 1 byte  ?  ?
 ? UUID N/A N/A  ?  ?  ? uniqueidentifier  ? UUID Not a data type, but a function SYS_GUID() will return a UUID as a RAW data type. UUID  ? IRI
 ? Row version N/A  ?  ?  ?  ? TIMESTAMP
ROWVERSION
 ?  ?  ?  ?  ?  ?
 ? Any data type N/A  ?  ?  ?  ? SQL_VARIANT  ?  ? ANYTYPE
ANYDATA
ANYDATASET
 ?  ?  ?