Open Source RDBMS - Seamless, Scalable, Stable and Free

한국어 | Login |Register

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)

comments powered by Disqus
Page info
viewed 2160 times
translations en
Author
posted 3 years ago by
hellohuizhang
Contributors
updated 2 years ago by
View revisions
Share this article