Background documentationSupported Data Types Locate this document in the navigation structure

 

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.

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

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

More Information

SQL Reference Manual, Data Type (data_type)