CUBRID vs. ODBC Data Type Mapping

CUBRID Data Type

ODBC Data Type

Char

SQL_CHAR

Varchar

SQL_VARCHAR

String

SQL_LONGVARCHAR

Nchar

SQL_CHAR

Varnchar

SQL_VARCHAR

Bit

SQL_BINARY

Varying bit

SQL_VARBINARY

Numeric

SQL_NUMERIC

Int

SQL_INTEGER

Short

SQL_SMALLINT

Float

SQL_FLOAT

Double

SQL_DOUBLE

Bigint

SQL_BIGINT

Date

SQL_TYPE_DATE

Time

SQL_TYPE_TIME

Timestamp

SQL_TYPE_TIMESTAMP

Datetime

SQL_TYPE_TIMESTAMP

Monetary

SQL_DOUBLE

Oid

SQL_CHAR(32)

set, multiset, sequence

SQL_VARCHAR(MAX_STRING_LENGTH)