Skip to content

[SQL兼容性]数值类型

lightfish edited this page Nov 30, 2020 · 2 revisions

数值类型

在Mycat中,所有MySQL数值类型都会被转换为Java的值对象

SQL类型 Java值类型
INTEGER int,Integer
BIGINT long,Long
SMALLINT short,Short
TINYINT byte,Byte
REAL float,Float
DOUBLE double,Double
BOOLEAN boolean,Boolean(网络协议输出为0,1)
VARBINARY byte[],ByteString
BLOB byte[],ByteString
VARCHAR String
CHAR String
TIMESTAMP LocalDateTime
TIME Duration
DECIMAL BigDecimal
DATE LocalDate
SET String
ENUM String
Clone this wiki locally