Data type conversion during data providing

For the providing phase (when you obtain data for the StorageDataSet component), JBDC data types are translated into corresponding JBCL data types. The JDBC data types listed below are defined in java.sql.Types. The JBCL data types are defined in borland.jbcl.util.Variant.

Precision, scale and type have default values if they are not explicitly. Precision and scale default to -1. Type defaults to Variant.STRING. The sqlType is based on the value returned from the JDBC driver.

For information on data mapping of SQL server physical types to JBDC data types, check your driver documentation.

JDBC type Maps to JBCL data type
java.sql.Types.BIGINT Variant.LONG
java.sql.Types.BINARY Variant.BINARY with precision
java.sql.Types.BIT Variant.BOOLEAN
java.sql.Types.CHAR Variant.STRING with precision
java.sql.Types.DATE Variant.DATE
java.sql.Types.DECIMAL Variant.BIGDECIMAL with scale and precision
java.sql.Types.DOUBLE Variant.DOUBLE
java.sql.Types.FLOAT Variant.DOUBLE
java.sql.Types.INTEGER Variant.INT
java.sql.Types.LONGVARBINARY Variant.BINARY without precision
java.sql.Types.LONGVARCHAR Variant.STRING without precision (BLOB columns typically have an open-ended length)
java.sql.Types.NUMERIC Variant.BIGDECIMAL with scale and precision
java.sql.Types.OTHER Variant.OBJECT
java.sql.Types.REAL Variant.DOUBLE
java.sql.Types.SMALLINT Variant.SHORT
java.sql.Types.TIME Variant.TIME
java.sql.Types.TIMESTAMP Variant.TIMESTAMP
java.sql.Types.TINYINT Variant.BYTE
java.sql.Types.VARBINARY Variant.BINARY without precision
java.sql.Types.VARCHAR Variant.STRING with precision