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

From Wikibooks, open books for an open world
Jump to navigation Jump to 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 N/A BIT
? Boolean storage size N/A ? ? ? ? 8 columns in a single table = 1 byte 1 byte 1 byte N/A 1 byte N/A ?
? 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 N/A IRI
? Row version N/A ? ? ? ? TIMESTAMP
ROWVERSION
? ? ? ? N/A ?
? Any data type N/A ? ? ? ? SQL_VARIANT ? ? ANYTYPE
ANYDATA
ANYDATASET
? (any) ?