| 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 | BIGINT |
| 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 | BIGINT |
 |
Discuss this page in DocCommentXchange.
|
Copyright © 2010, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.0 |