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).