数据类型

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