The CUBRID ODBC driver supports ODBC version 3.52, ODBC core, and some of Level 1 and Level 2 APIs. Since it has been developed based on ODBC Spec 3.x, backward compatibility is not completely ensured for programs written using ODBC Spec 2.x. Only 32 bit are supported. In the 64-bit Windows environment, you can check the ODBC driver with CUBRID 32 bit by executing "C:\Windows\SysWOW64\odbcad32.exe."
For more information on configuring CUBRID ODBC driver, see "Getting Started with CUBRID > Programming with ODBC and ASP > Configuring the Environment of ODBC and ASP."
The following table shows the data mapping relationship between data types of ODBC and those supported by CUBRID.
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) |