The data type conversions used by the input values of Java Scalar UDFs and Java Table UDFs.
| SQL type | Java Type |
|---|---|
| BIGINT | long |
| BINARY | byte[ ] |
| BIT | boolean |
| CHAR | String |
| DATE | java.sql.Date |
| DECIMAL | java.math.BigDecimal |
| DOUBLE | double |
| IMAGE | byte[ ] |
| INTEGER | int |
| LONG BINARY | byte[ ] Note: Large object data support requires a
separately licensed SAP Sybase IQ
option.
|
| LONG VARCHAR | String Note: Large object data support requires a
separately licensed SAP Sybase IQ
option.
|
| MONEY | java.math.BigDecimal |
| NUMERIC | java.math.BigDecimal |
| REAL | float |
| SMALLINT | short |
| SMALLMONEY | java.math.BigDecimal |
| TEXT | String |
| TIME | java.sql.Time |
| TIMESTAMP | java.sql.Timestamp |
| TINYINT | byte |
| UNSIGNED BIGINT | java.math.BigDecimal (with a precision of 20 and scale of 0) |
| UNSIGNED INT | java long |
| VARBINARY | byte[ ] |
| VARCHAR | String |