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

From Wikibooks, open books for an open world
Jump to: navigation, search

Misc types[edit]

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  ? N/A  ? UUID  ? IRI
 ? Row version N/A  ?  ?  ?  ? TIMESTAMP
ROWVERSION
 ?  ?  ?  ?  ?  ?
 ? Any data type N/A  ?  ?  ?  ? SQL_VARIANT  ?  ? ANYTYPE
ANYDATA
ANYDATASET
 ?  ?  ?