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 |
