Help Center/ GaussDB/ M-Compatibility Developer Guide(Centralized)/ Application Development Guide/ Development Based on MySQL JDBC/ Appendix/ JDBC Data Type Mapping
Updated on 2025-10-23 GMT+08:00
View PDF
Share

JDBC Data Type Mapping

For M-Compatible databases, Table 1 shows the index relationships among data types, Java variable types, and JDBC types.

Table 1 JDBC Data Type Mapping

Gauss Kernel Data Type

Java Variable Type

JDBC Type Index

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
Parent topic: Appendix