Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SAP Sybase SQL Anywhere 16.0 (中文) » SQL Anywhere 服务器 - SQL 参考 » SQL 数据类型 » 数据类型转换 » Java 和 SQL 数据类型转换

 

SQL 到 Java 数据类型转换

SQL 类型 Java 类型
CHAR String
VARCHAR String
TEXT String
NUMERIC java.math.BigDecimal
DECIMAL java.math.BigDecimal
MONEY java.math.BigDecimal
SMALLMONEY java.math.BigDecimal
UNSIGNED BIGINT java.math.BigDecimal (precision=20, scale=0)
BIT boolean
TINYINT byte
SMALLINT short
UNSIGNED SMALLINT int
INTEGER int
UNSIGNED INTEGER long
BIGINT long
REAL float
FLOAT double
DOUBLE double
BINARY byte[ ]
VARBINARY byte[ ]
LONG BINARY byte[ ]
IMAGE byte[ ]
DATE java.sql.Date
TIME java.sql.Time
TIMESTAMP java.sql.Timestamp