Equivalent SQL Data Types

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