GBase 8s数据类型与java.sql.Types对应关系
对应版本:3.6.2_2
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 |
CLOB2 | -1 | LONGVARCHAR |