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) ?
最后修改: 2025年04月11日 星期五 09:56