SQL Anywhere® Server - SQL Reference
SQL Data Types
Java and SQL data type conversion
SQL to Java data type conversion
| 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 |
| BIT | boolean |
| TINYINT | byte |
| SMALLINT | short |
| INTEGER | int |
| BIGINT | long |
| REAL | float |
| FLOAT | double |
| DOUBLE | double |
| BINARY | byte[ ] |
| VARBINARY | byte[ ] |
| LONG VARBINARY | byte[ ] |
| IMAGE | byte[ ] |
| DATE | java.sql.Date |
| TIME | java.sql.Time |
| TIMESTAMP | java.sql.Timestamp |