数据类型 |
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 |
|
![](https://img2024.cnblogs.com/blog/35695/202408/35695-20240826070647288-243310440.jpg)