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 |
STRING |
a_rdb_SQL_DT_STRING |
|
|
4 |
BIGINT |
|
0xF1 |
|
5 |
INTEGER#1 |
|
0xF5 |
|
6 |
SMALLINT#2 |
a_rdb_SQL_DT_INT2 |
0xF7 |
|
7 |
DECIMAL |
a_rdb_SQL_DT_DEC |
0xE5 |
|
8 |
NUMERIC |
a_rdb_SQL_DT_NUMERIC |
|
|
9 |
REAL |
a_rdb_SQL_DT_REAL |
0xE3 |
|
10 |
DOUBLE PRECISION |
a_rdb_SQL_DT_DOUBLE |
0xE1 |
|
11 |
FLOAT |
a_rdb_SQL_DT_FLOAT |
|
|
12 |
DATE |
a_rdb_SQL_DT_DATE |
0x71 |
|
13 |
TIME |
a_rdb_SQL_DT_TIME |
0x79 |
|
14 |
TIMESTAMP WITHOUT TIME ZONE |
a_rdb_SQL_DT_TIMESTAMP |
0x7D |
|
15 |
TIMESTAMP WITH TIME ZONE |
a_rdb_SQL_DT_TIMESTAMP_TZ |
0x7F |
|
16 |
BINARY |
a_rdb_SQL_DT_BINARY |
0x95 |
|
17 |
VARBINARY |
a_rdb_SQL_DT_VARBINARY |
0x91 |
|
18 |
BOOLEAN |
a_rdb_SQL_DT_BOOLEAN |
0x21 |
|
19 |
UUID |
a_rdb_SQL_DT_UUID |
0x9B |
|
20 |
ROW |
a_rdb_SQL_DT_ROW |
0x45 |
- #1
-
If the integer data type format is in legacy format, the symbolic literal is a_rdb_SQL_DT_INT and the value is 0xF1.
- #2
-
If the integer data type format is in legacy format, the symbolic literal is a_rdb_SQL_DT_SMALLINT and the value is 0xF5.