Home | Previous Page | Next Page   Data Types > Converting Data >

Standard Conversions

The following table shows the supported conversions between the Informix SQL data types and the Informix ODBC Driver C data types. An X indicates a supported conversion.

Dynamic Server

Only Dynamic Server can convert data to SQL_C_BIT.

End of Dynamic Server
Informix SQL Data Type Informix ODBC Driver C Data Type (Target Type)
SQL_C_BINARY SQL_C_BIT SQL_C_CHAR SQL_C_WCHAR SQL_C_DATE SQL_C_DOUBLE SQL_C_FLOAT SQL_C_LONG SQL_C_NUMERIC SQL_C_SHORT SQL_C_SLONG SQL_C_SSHORT SQL_C_STINYINT SQL_C_TIMESTAMP SQL_C_TINYINT SQL_C_ULONG SQL_C_USHORT SQL_C_UTINYINT
BOOLEAN (IDS) X X X X
BYTE X X X
CHAR, CHARACTER X X X X X X X X X X X X X X X X
CHARACTER VARYING X X X X X X X X X X X X X X X X
DATE X X X X X
DATETIME X X X X X
DEC, DECIMAL X X X X X X X X X X X X X X X X
DOUBLE PRECISION X X X X X X X X X X X X X X X
FLOAT X X X X X X X X X X X X X X X
INT, INTEGER X X X X X X X X X X X X X X X X
INT8 (IDS) X X X X X X X X
LVARCHAR (IDS) X X X X X X X X X X X X X X X X
MONEY X X X X X X X X X X X X X X X X X
NUMERIC X X X X X X X X X X X X X X X X X
REAL X X X X X X X X X X X X X X X X X
SERIAL X X X X X X X X X X X X X X X X
SERIAL8 (IDS) X X X X X X X X X X
SMALLFLOAT X X X X X X X X X X X X X X X X
SMALLINT X X X X X X X X X X X X X X X X
TEXT X X X X X X X X X X X X X X X X X X
VARCHAR X X X X X X X X X X X X X X X X X X
Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]