与一般数据库一样。
INTEGER java.lang.Integer -2147483648 to 2147483647 (4 byte)
UNSIGNED_INT java.lang.Integer 0 to 2147483647 (4 byte )
BIGINTjava.lang.Long-9223372036854775807 to
9223372036854775807 8 byte
UNSIGNED_LONG java.lang.Long 0 to 9223372036854775807
TINYINTjava.lang.Byte-128 to 127 1
byte
UNSIGNED_TINYINT java.lang.Byte 0 to 127 1 byte
SMALLINTjava.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[]