JDBC数据类型映射关系
在M-Compatibility模式数据库下,数据类型、JAVA变量类型以及JDBC类型索引关系如表1所示。
|
Gauss Kernel数据类型 |
JAVA变量类型 |
JDBC类型索引 |
|---|---|---|
|
TINYINT |
java.lang.Integer |
Types.TINYINT |
|
TINYINT UNSIGNED |
java.lang.Integer |
Types.TINYINT |
|
SMALLINT |
java.lang.Integer |
Types.SMALLINT |
|
SMALLINT UNSIGNED |
java.lang.Integer |
Types.SMALLINT |
|
INT |
java.lang.Integer |
Types.INTEGER |
|
INT UNSIGNED |
java.lang.Long |
Types.INTEGER |
|
MEDIUMINT |
java.lang.Integer |
Types.INTEGER |
|
MEDIUMINT UNSIGNED |
java.lang.Integer |
Types.INTEGER |
|
BIGINT |
java.lang.Long |
Types.BIGINT |
|
BIGINT UNSIGNED |
java.math.BigInteger |
Types.BIGINT |
|
NUMERIC |
java.math.BigDecimal |
Types.DECIMAL |
|
FLOAT4 |
java.lang.Float |
Types.REAL |
|
FLOAT8 |
java.lang.Double |
Types.DOUBLE |
|
BIT |
java.lang.Boolean |
Types.BIT |
|
BOOL/BOOLEAN |
java.lang.Boolean |
Types.BIT |
|
CHAR |
java.lang.String |
Types.CHAR |
|
VARCHAR |
java.lang.String |
Types.VARCHAR |
|
TEXT |
java.lang.String |
Types.LONGVARCHAR |
|
TINYTEXT |
java.lang.String |
Types.LONGVARCHAR |
|
MEDIUMTEXT |
java.lang.String |
Types.LONGVARCHAR |
|
LONGTEXT |
java.lang.String |
Types.LONGVARCHAR |
|
BINARY |
byte[] |
Types.BINARY |
|
VARBINARY |
byte[] |
Types.VARBINARY |
|
TINYBLOB |
byte[] |
Types.VARBINARY |
|
BLOB |
byte[] |
Types.LONGVARBINAR |
|
MEDIUMBLOB |
byte[] |
Types.LONGVARBINAR |
|
LONGBLOB |
byte[] |
Types.LONGVARBINAR |
|
DATE |
java.sql.Date |
Types.DATE |
|
TIME |
java.sql.Time |
Types.TIME |
|
TIMESTAMP |
java.sql.Timestamp |
Types.TIMESTAMP |
|
DATETIME |
java.sql.Timestamp |
Types.TIMESTAMP |
|
YEAR |
java.sql.Date |
Types.DATE |
|
SET |
java.lang.String |
Types.CHAR |
|
ENUM |
java.lang.String |
Types.CHAR |