Data Conversions Supported by the OpenAccess SDK SQL Engine

○ = Default Conversion ● = Supported Conversion

The OpenAccess Data Type is of the format: XO_TYPE_XXXX.

Only the XXXX portion of the name is represented in the table.

For example, XO_TYPE_CHAR is represented in the table rows and columns as CHAR.

OpenAccess Data Type

CHAR

NUMERIC

DECIMAL

INTEGER

SMALLINT

FLOAT

REAL

DOUBLE

DATE

TIME

TIMESTAMP

VARCHAR

LONGVARCHAR

BINARY

VARBINARY

LONGVARBINARY

TINYINT

BIT

WCHAR

WVARCHAR

WLONGVARCHAR

CHAR

○

●

●

●

●

●

●

●

●

●

●

●

●

●

●

●

●

●

●

●

●

CHAR

NUMERIC

●

○

●

●

●

●

●

●

●

●

●

●

●

●

●

●

●

●

●

●

●

NUMERIC

DECIMAL

●

●

○

●

●

●

●

●

●

●

●

●

●

●

●

●

●

●

●

●

●

DECIMAL

INTEGER

●

●

●

○

●

●

●

●

●

●

●

●

●

INTEGER

SMALLINT

●

●

●

●

○

●

●

●

●

●

●

●

●

SMALLINT

FLOAT

●

●

●

●

●

○

●

●

●

●

●

●

●

FLOAT

REAL

●

●

●

●

●

●

○

●

●

●

●

●

●

REAL

DOUBLE

●

●

●

●

●

●

●

○

●

●

●

●

●

DOUBLE

DATE

●

○

●

●

●

●

DATE

TIME

●

●

○

●

●

●

●

TIME

TIMESTAMP

●

●

●

○

●

●

●

TIMESTAMP

VARCHAR

●

●

●

●

●

●

●

●

●

●

●

○

●

●

●

●

●

●

●

●

●

VARCHAR

LONGVARCHAR

○

LONGVARCHAR

BINARY

○

BINARY

VARBINARY

○

VARBINARY

LONGVARBINARY

○

LONGVARBINARY

TINYINT

●

●

●

●

●

●

●

●

●

○

●

TINYINT

BIT

●

●

●

●

●

●

●

●

●

●

○

BIT

WCHAR

●

●

●

●

●

●

●

●

●

●

●

●

●

●

●

●

●

●

○

●

●

WCHAR

WVARCHAR

●

●

●

●

●

●

●

●

●

●

●

●

●

●

●

●

●

●

●

○

●

WVARCHAR

WLONGVARCHAR

○

WLONGVARCHAR

CHAR

NUMERIC

DECIMAL

INTEGER

SMALLINT

FLOAT

REAL

DOUBLE

DATE

TIME

TIMESTAMP

VARCHAR

LONGVARCHAR

BINARY

VARBINARY

LONGVARBINARY

TINYINT

BIT

WCHAR

WVARCHAR

WLONGVARCHAR