Open Source RDBMS - Seamless, Scalable, Stable and Free

한국어 | Login |Register

Versions available for this page: CUBRID 8.2.1 |  CUBRID 8.3.0 |  CUBRID 8.3.1 |  CUBRID 8.4.0 |  CUBRID 8.4.1 | 

CUBRID ODBC Driver

Description

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 Configuring the Environment of ODBC and ASP.

Data Type Mapping of CUBRID and ODBC

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)