|
数据类型 |
Java Map |
占用大小 (byte) |
范围 |
|
INTEGER |
java.lang.Integer |
4 |
-2147483648 to 2147483647 |
|
UNSIGNED_INT |
java.lang.Integer |
4 |
0 to 2147483647 |
|
BIGINT |
java.lang.Long |
8 |
-9223372036854775807 to 9223372036854775807 |
|
UNSIGNED_LONG |
java.lang.Long |
8 |
0 to 9223372036854775807 |
|
TINYINT |
java.lang.Byte |
1 |
-128 to 127 |
|
UNSIGNED_TINYINT |
java.lang.Byte |
1 |
0 to 127 |
|
SMALLINT |
java.lang.Short |
2 |
-32768 to 32767 |
|
UNSIGNED_SMALLINT |
java.lang.Short |
2 |
0 to 32767 |
|
FLOAT |
java.lang.Float |
4 |
-3.402823466 E + 38 to 3.402823466 E + 38 |
|
UNSIGNED_FLOAT |
java.lang.Float |
4 |
0 to 3.402823466 E + 38 |
|
DOUBLE |
java.lang.Double |
8 |
-1.7976931348623158 E + 308 to 1.7976931348623158 E + 308 |
|
UNSIGNED_DOUBLE |
java.lang.Double |
8 |
0 to 1.7976931348623158 E + 308 |
|
DECIMAL |
java.math.BigDecimal |
DECIMAL(p,s) |
|
|
BOOLEAN |
java.lang.Boolean |
1 |
TRUE and FALSE |
|
TIME |
java.sql.Time |
8
|
yyyy-MM-dd hh:mm:ss |
|
DATE |
java.sql.Date |
8 |
yyyy-MM-dd hh:mm:ss, |
|
TIMESTAMP |
java.sql.Timestamp |
12 |
yyyy-MM-dd hh:mm:ss[.nnnnnnnnn] |
|
UNSIGNED_TIME |
java.sql.Time |
8 |
yyyy-MM-dd hh:mm:ss |
|
UNSIGNED_DATE |
java.sql.Date |
8 |
yyyy-MM-dd hh:mm:ss |
|
UNSIGNED_TIMESTAMP |
java.sql.Timestamp |
12 |
|
|
VARCHAR |
java.lang.String |
VARCHAR(n) |
|
|
CHAR |
java.lang.String |
CHAR (n)
|
|
|
BINARY |
byte[] |
BINARY(n) |
|
|
VARBINARY |
byte[] |
VARBINARY |
|
|
ARRAY |
java.sql.Array |
VARCHAR ARRAY |
|