# Preferred getXXX() methods for Derby-style table functions

While scanning a Derby-style table function, Derby calls a preferred getXXX() method for each column, based on the column's data type.

The following table lists the preferred getXXX() method for each Derby data type.

Table 1. getXXX() methods called for declared SQL types
Column Type Declared by CREATE FUNCTION | getXXX() Method Called by Derby
--- | ---
BIGINT | getLong()
BLOB | getBlob()
CHAR | getString()
CHAR FOR BIT DATA | getBytes()
CLOB | getClob()
DATE | getDate()
DECIMAL | getBigDecimal()
DOUBLE | getDouble()
DOUBLE PRECISION | getDouble()
FLOAT | getDouble()
INTEGER | getInt()
LONG VARCHAR | getString()
LONG VARCHAR FOR BIT DATA | getBytes()
NUMERIC | getBigDecimal()
REAL | getFloat()
SMALLINT | getShort()
TIME | getTime()
TIMESTAMP | getTimestamp()
VARCHAR | getString()
VARCHAR FOR BIT DATA | getBytes()
XML | Not supported

Parent topic: Overview of Derby-style table functions