SQL Anywhere® Server - SQL Reference
SQL Data Types
Java and SQL data type conversion
Java to SQL data type conversion
| Java type | SQL type |
|---|---|
| String | CHAR |
| String | VARCHAR |
| String | TEXT |
| java.math.BigDecimal | NUMERIC |
| java.math.BigDecimal | MONEY |
| java.math.BigDecimal | SMALLMONEY |
| boolean | BIT |
| byte | TINYINT |
| Short | SMALLINT |
| Int | INTEGER |
| long | INTEGER |
| float | REAL |
| double | DOUBLE |
| byte[ ] | VARBINARY |
| byte[ ] | IMAGE |
| java.sql.Date | DATE |
| java.sql.Time | TIME |
| java.sql.Timestamp | TIMESTAMP |
| java.lang.Double | DOUBLE |
| java.lang.Float | REAL |
| java.lang.Integer | INTEGER |
| java.lang.Long | INTEGER |
| void |
this1 |
1The method returns the object itself