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