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 Server - SQL Reference » SQL data types » Data type conversions » Java and SQL data type conversions

 

SQL to Java data type conversions

SQL type Java type
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