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