| BIGINT |
|
|
|
INT8 |
|
|
|
INT4|INT2|DECIMAL|NUMERIC |
| INTEGER |
|
|
|
INT4 |
|
|
|
INT8|INT2|DECIMAL|NUMERIC |
| SMALLINT |
|
|
|
INT2 |
|
|
|
INT4|INT8|DECIMAL|NUMERIC |
| REAL |
|
|
|
FLOAT8 |
|
|
|
|
| DOUBLE |
|
|
|
FLOAT8 |
|
|
|
|
| DECIMAL |
P<=15 |
s!=0 |
|
FLOAT8 |
|
|
|
|
| DECIMAL |
P<=2 |
s=0 |
|
SMALLINT |
|
|
|
|
| DECIMAL |
2<P<=4 |
s=0 |
|
INT2 |
|
|
|
|
| DECIMAL |
4<P<=18 |
s=0 |
|
INT8 |
|
|
|
|
| DECIMAL |
|
|
|
DECIMAL |
|
|
|
|
| DECFLOAT |
|
|
|
FLOAT |
|
|
|
DECIMAL |
| CHARACTER |
|
|
|
CHAR |
|
|
|
|
| VARCHAR |
|
|
0<=L<=8000 |
VARCHAR |
|
|
|
|
| VARCHAR |
|
|
8001<=L<=32672 |
CLOB |
|
|
|
|
| LONG VARCHAR |
|
|
|
CLOB |
|
|
|
|
| GRAPHIC |
|
|
|
CHAR |
|
|
2 |
|
| VARGRAPHIC |
|
|
0<=L<=4000 |
VARCHAR |
|
|
2 |
|
| VARGRAPHIC |
|
|
4001<=L<=16350 |
CLOB |
|
|
|
|
| LONG GRAPHIC |
|
|
0<=L<=4000 |
VARCHAR |
|
|
2 |
|
| LONG VARGRAPHIC |
|
|
4001<=L<=16350 |
CLOB |
|
|
|
|
| CLOB |
|
|
|
CLOB |
|
|
|
|
| DBCLOB |
|
|
|
CLOB |
|
|
|
|
| BLOB |
|
|
|
BLOB |
|
|
|
|
| DATE |
|
|
|
DATE |
|
|
|
|
| TIME |
|
|
|
TIME |
|
|
|
|
| TIMESTAMP |
|
|
|
TIMESTAMP |
|
|
|
|
| XML |
|
|
|
XML |
|
|
|
CLOB |