Supported Data Types

The ODBC interface distinguishes between the following data types:

?     SQL data types (data types provided by the database system)

?     C data types (data types used in the application)

The MaxDB ODBC driver enables the conversion of all data types supported by ODBC.

MaxDB Data Types Supported by the MaxDB ODBC Driver (SQL Data Types)

Group

Data Type

Character

CHAR, VARCHAR, LONG, CHAR BYTE, VARCHAR BYTE, LONG BYTE

Numeric

DECIMAL, FIXED, INTEGER, SMALLINT, FLOAT, REAL, DOUBLE PRECISION

Time/date

DATE, TIME, TIMESTAMP

Other

BOOLEAN, CHAR EBCDIC, VARCHAR EBCDIC

For more information about MaxDB data types, see SQL Reference Manual, Data Type (data_type).