与一般数据库一样。
INTEGER java.lang.Integer -2147483648 to 2147483647 (
4 byte
)
UNSIGNED_INT java.lang.Integer 0 to 2147483647 (4 byte )
BIGINT
java.lang.
Long
-9223372036854775807 to 9223372036854775807
8 byte
UNSIGNED_LONG java.lang.Long 0 to 9223372036854775807
TINYINT
java.lang.
Byte
-128 to 127
1 byte
UNSIGNED_TINYINT java.lang.Byte 0 to 127 1 byte
SMALLINT
java.lang.
Short
-32768 to 32767
2 byte
UNSIGNED_SMALLINT java.lang.Short 0 to 32767 2 byte
FLOAT java. lang.Float -3.402823466 E + 38 to 3.402823466 E + 38
4 byte
UNSIGNED_FLOAT java.lang.Float -3.402823466 E + 38 to 3.402823466 E + 38 4 byte
DOUBLE java.lang.Double -1.7976931348623158 E+308 to 1.7976931348623158 E+308
8 byte
UNSIGNED_DOUBLE java.lang.Double 0 to 1.7976931348623158 E + 308 8 byte
DECIMAL java.math.BigDecimal 38 digits
BOOLEAN java.lang.Boolean
TIME java.sql.Time
DATE java.sql.Date
TIMESTAMP java.sql.Timestamp
UNSIGNED_TIME java.sql.Time
UNSIGNED_DATE java.sql.Date
UNSIGNED_TIMESTAMP java.sql.Timestamp
VARCHAR(
precisionInt
) java.lang.String
CHAR (
precisionInt
)
java.lang.String
BINARY (
precisionInt
) byte[]
VARBINARY byte[]