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 SAP MaxDB ODBC driver enables the conversion of all data types supported by ODBC.
Group |
Data Type |
---|---|
Character |
CHAR, VARCHAR, CLOB, CHAR BYTE, VARCHAR BYTE, BLOB |
Numeric |
DECIMAL, FIXED, INTEGER, SMALLINT, FLOAT, REAL, DOUBLE PRECISION |
Time/date |
DATE, TIME, TIMESTAMP |
Other |
BOOLEAN |
SQL Reference Manual, Data Type (data_type)