InterBase 7.1 DataType to JDBC DataType Map

Dialect 3 Datatype Mappings

The following table defines the bindings between InterBase SQL datatypes and Java Object Type mappings. All SQL compliant InterBase datatypes are fully supported by InterClient 4.0. All Java client applications should consider using this table for ResultSet data retrieval using the ResultSet.getXXX methods.

Dialect 1 Datatype Mappings

Map your own table

To get more extensive datatype mappings on your own tables, try the following methods:

• ResultSetMetaData.getColumnName(col_number)
Use this to get the metadata name for specified column.
• ResultSetMetaData.getColumnTypeName(col_number)
Use this to get the JDBC/SQL type name of specified column.
• ResultSetMetaData.getColumnType(col_number)
Use this to get the numeric JDBC type of specified column.
• ResultSetMetaData.getPrecision(col_number)
Use this to get maximum precision of specified column.
• ResultSetMetaData.getScale(col_number)
Use this to get the scale of specified column.
• ResultSetMetaData.getColumnClassName(col_number)
Use this to get the Class name of the Java class to which the specified column will be mapped.
• ResultSet.getObject(col_number).getClass().getName()
This is a nice way to get the 'true' mapping of each column in your table.