| SQL:2016 | MySQL | PostgreSQL | MSSQL | Oracle |
|---|---|---|---|---|
| Character Types | ||||
| Character (CHAR) | x | x | x | x |
| Character Varying (VARCHAR) | x | x | x | x |
| Character Large Object (CLOB) | x | x | x | x |
| Binary Types | ||||
| Binary (BINARY) | x | x | x | x |
| Binary Varying (VARBINARY) | x | x | x | x |
| Binary Large Object (BLOB) | x | x | x | x |
| Numeric Types | ||||
| Exact Numeric Types (NUMERIC, DECIMAL, SMALLINT, INTEGER, BIGINT) | x | x | x | x |
| Approximate Numeric Types (FLOAT, REAL, DOUBLE PRECISION) | x | x | x | x |
| Datetime Types (DATE, TIME, TIMESTAMP) | ||||
| Interval Type (INTERVAL) | ||||
| Boolean | ||||
| XML | ||||
| JSON (since SQL:2016) | ||||