C Data Type
|
C Data Value
|
SQL Data Type
|
Column Length
|
SQL Data Value
|
SQLSTATE
|
---|---|---|---|---|---|
SQL_C_CHAR
|
abcdef\0 [a]
|
SQL_CHAR
|
6
|
abcdef
|
N/A
|
SQL_C_CHAR
|
abcdef\0 [a]
|
SQL_CHAR
|
5
|
abcde
|
22001
|
SQL_C_CHAR
|
1234.56\0 [a]
|
SQL_DECIMAL
|
8 [b]
|
1234.56
|
N/A
|
SQL_C_CHAR
|
1234.56\0 [a]
|
SQL_DECIMAL
|
7 [b]
|
1234.5
|
22001
|
SQL_C_CHAR
|
1234.56\0 [a]
|
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 [c]
|
SQL_CHAR
|
10
|
1992-12-31
|
N/A
|
SQL_C_TYPE_DATE
|
1992,12,31 [c]
|
SQL_CHAR
|
9
|
----
|
22003
|
SQL_C_TYPE_DATE
|
1992,12,31 [c]
|
SQL_TIMESTAMP
|
not applicable
|
1992-12-31 00:00:00.0
|
N/A
|
SQL_C_TYPE TIMESTAMP
|
1992,12,31, 23,45,55, 120000000 [d]
|
SQL_CHAR
|
22
|
1992-12-31 23:45:55.12
|
N/A
|
SQL_C_TYPE TIMESTAMP
|
1992,12,31, 23,45,55, 120000000 [d]
|
SQL_CHAR
|
21
|
1992-12-31 23:45:55.1
|
22001
|
SQL_C_TYPE TIMESTAMP
|
1992,12,31, 23,45,55, 120000000 [d]
|
SQL_CHAR
|
18
|
----
|
22003
|