GBase 8s数据类型与java.sql.Types对应关系
| GBase 8s类型类型 | java.sql.Types | java类型名称 |
|---|
| SMALLINT | 5 | SMALLINT |
| INTEGER | 4 | INTEGER |
| BIGINT | -5 | BIGINT |
| INT8 | -5 | BIGINT |
| SMALLFLOAT | 7 | REAL |
| FLOAT | 8 | DOUBLE |
| DECIMAL | 3 | DECIMAL |
| MONEY | 3 | DECIMAL |
| CHAR | 1 | CHAR |
| NCHAR | 1 | CHAR |
| VARCHAR | 12 | VARCHAR |
| NVARCHAR | 12 | VARCHAR |
| VARCHAR2 | 63 | 未定义 |
| LVARCHAR | -1 | LONGVARCHAR |
| BOOLEAN | 16 | BOOLEAN |
| TEXT | 2005 | CLOB |
| BYTE | 2004 | BLOB |
| CLOB | 2005 | CLOB |
| BLOB | 2004 | BLOB |
| SERIAL | 4 | INTEGER |
| SERIAL8 | -5 | BIGINT |
| BIGSERIAL | -5 | BIGINT |
| DATETIME YEAR TO SECOND | 93 | TIMESTAMP |
| DATETIME HOUR TO SECOND | 92 | TIME |
| DATE | 91 | DATE |
| RAW | -1 | LONGVARCHAR |
| TIMESTAMP WITH TIME ZONE | 0 | NULL |
| 未定义 | 2013 | TIMESTAMP_WITH_TIMEZONE |
| 未定义 | 2012 | TIME_WITH_TIMEZONE |
| JSON | -1 | LONGVARCHAR |
| BSON | -1 | LONGVARCHAR |
| INTERVAL | 1 | CHAR |
| LIST | 1111 | OTHER |
| SET（LVARCHAR) | -1 | LONGVARCHAR |
| MULTISET（SENDRECEIVE） | 1111 | OTHER |
