19.6.1 Correspondences among SQL data types, symbolic literals, and values
The following table shows the correspondences among the SQL data types, the symbolic literals, and the values.
|
No. |
SQL data type |
Symbolic literal |
Value |
|---|---|---|---|
|
1 |
CHAR |
a_rdb_SQL_DT_CHAR |
0xC5 |
|
2 |
VARCHAR |
a_rdb_SQL_DT_VARCHAR |
0xC1 |
|
3 |
INTEGER |
a_rdb_SQL_DT_INT |
0xF1 |
|
4 |
SMALLINT |
a_rdb_SQL_DT_SMALLINT |
0xF5 |
|
5 |
DECIMAL |
a_rdb_SQL_DT_DEC |
0xE5 |
|
6 |
DOUBLE PRECISION |
a_rdb_SQL_DT_DOUBLE |
0xE1 |
|
7 |
DATE |
a_rdb_SQL_DT_DATE |
0x71 |
|
8 |
TIME |
a_rdb_SQL_DT_TIME |
0x79 |
|
9 |
TIMESTAMP |
a_rdb_SQL_DT_TIMESTAMP |
0x7D |
|
10 |
BINARY |
a_rdb_SQL_DT_BINARY |
0x95 |
|
11 |
VARBINARY |
a_rdb_SQL_DT_VARBINARY |
0x91 |
|
12 |
ROW |
a_rdb_SQL_DT_ROW |
0x45 |