The following table lists the equivalent Microsoft SQL and ANSI SQL data types.
Microsoft SQL | ANSI SQL |
BINARY | Not supported |
BOOLEAN | Not supported |
BYTE | Not supported |
CURRENCY | Not supported |
DATETIME | Not supported |
DOUBLE | REAL |
LONG | INT[EGER] |
LONGBINARY | Not supported |
LONGTEXT | VARCHAR |
SHORT | SMALLINT |
SINGLE | FLOAT |
TEXT | CHAR[ACTER] |
Not supported | NUMBER |
Not supported | NUMERIC |
Not supported | DECIMAL |
Not supported | DOUBLE PRECISION |
Not supported | PICTURE |