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

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.

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)	?