SQL Type Identifier
|
SQL Data Values
|
C Type Identifier
|
Buffer Length
|
*TargetValuePtr
|
SQLSTATES
|
---|---|---|---|---|---|
SQL_CHAR
|
abcdef
|
SQL_C_CHAR
|
7
|
abcdef\0 [a]
|
N/A
|
SQL_CHAR
|
abcdef
|
SQL_C_CHAR
|
6
|
abcde\0 [a]
|
01004
|
SQL_DECIMAL
|
1234.56
|
SQL_C_CHAR
|
8
|
1234.56\0 [a]
|
N/A
|
SQL_DECIMAL
|
1234.56
|
SQL_C_CHAR
|
5
|
1234\0 [a]
|
01004
|
SQL_DECIMAL
|
1234.56
|
SQL_C_CHAR
|
4
|
----
|
22003
|
SQL_DECIMAL
|
1234.56
|
SQL_C_FLOAT
|
ignored
|
1234.56
|
N/A
|
SQL_DECIMAL
|
1234.56
|
SQL_C_SSHORT
|
ignored
|
1234
|
01S07
|
SQL_DECIMAL
|
1234.56
|
SQL_C_STINYINT
|
ignored
|
----
|
22003
|
SQL_DOUBLE
|
1.2345678
|
SQL_C_DOUBLE
|
ignored
|
1.2345678
|
N/A
|
SQL_DOUBLE
|
1.2345678
|
SQL_C_FLOAT
|
ignored
|
1.234567
|
N/A
|
SQL_DOUBLE
|
1.2345678
|
SQL_C_STINYINT
|
ignored
|
1
|
N/A
|
SQL_TYPE_DATE
|
1992-12-31
|
SQL_C_CHAR
|
11
|
1992-12-31\0 [a]
|
N/A
|
SQL_TYPE_DATE
|
1992-12-31
|
SQL_C_CHAR
|
10
|
|
22003
|
SQL_TYPE_DATE
|
1992-12-31
|
SQL_C_ TIMESTAMP
|
ignored
|
1992,12,31, 0,0,0,0 [b]
|
N/A
|
SQL_TYPE_TIMESTAMP
|
1992-12-31 23:45:55.12
|
SQL_C_CHAR
|
23
|
1992-12-31 23:45:55.12\0 [a]
|
N/A
|
SQL_TYPE_TIMESTAMP
|
1992-12-31 23:45:55.12
|
SQL_C_CHAR
|
22
|
1992-12-31 23:45:55.1\0 [a]
|
01004
|
SQL_TYPE_TIMESTAMP
|
1992-12-31 23:45:55.12
|
SQL_C_CHAR
|
18
|
----
|
22003
|