The return-value data types of Java scalar UDFs and Java Table UDFs.
| 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 | DATETIME/TIMESTAMP |
| java.lang.Double | DOUBLE |
| java.lang.Float | REAL |
| java.lang.Integer | INTEGER |
| java.lang.Long | BIGINT |