C to SQL data conversion examples

C data type	C data value	SQL data type	Column length	SQL data value	SQLSTATE
SQL_C_CHAR	abcdef\0 [1]	SQL_CHAR	6	abcdef	N/A
SQL_C_CHAR	abcdef\0 [1]	SQL_CHAR	5	abcde	22001
SQL_C_CHAR	1234.56\0 [1]	SQL_DECIMAL	8 [2]	1234.56	N/A
SQL_C_CHAR	1234.56\0 [1]	SQL_DECIMAL	7 [2]	1234.5	22001
SQL_C_CHAR	1234.56\0 [1]	SQL_DECIMAL	4	----	22003
SQL_C_FLOAT	1234.56	SQL_FLOAT	not applicable	1234.56	N/A
SQL_C_FLOAT	1234.56	SQL_INTEGER	not applicable	1234	22001
SQL_C_FLOAT	1234.56	SQL_TINYINT	not applicable	----	22003
SQL_C_TYPE_DATE	1992,12,31 [3]	SQL_CHAR	10	1992-12-31	N/A
SQL_C_TYPE_DATE	1992,12,31 [3]	SQL_CHAR	9	----	22003
SQL_C_TYPE_DATE	1992,12,31 [3]	SQL_TIMESTAMP	not applicable	1992-12-31 00:00:00.0	N/A
SQL_C_TYPE TIMESTAMP	1992,12,31, 23,45,55, 120000000 [4]	SQL_CHAR	22	1992-12-31 23:45:55.12	N/A
SQL_C_TYPE TIMESTAMP	1992,12,31, 23,45,55, 120000000 [4]	SQL_CHAR	21	1992-12-31 23:45:55.1	22001
SQL_C_TYPE TIMESTAMP	1992,12,31, 23,45,55, 120000000 [4]	SQL_CHAR	18	----	22003