Data Type Conversions

This chapter provides a table for Data Type Conversions.

Data Type Conversions Table

Table 50 lists the data type conversions that are supported by the Teradata JDBC Driver.

Table 50: Data Type Conversions Table
Teradata Data Type	JDBC Data Type	ResultSet Methods	getObject Return Type	Prepared Statement Methods	setObject Argument Types
BYTEINT	TINYINT	getByte getShort getInt getLong getFloat getDouble getBigDecimal getString getObject	Integer	setByte setShort setInt setLong setFloat setDouble setBigDecimal setString setObject	Byte Short Integer Long Float Double BigDecimal String
SMALLINT	SMALLINT	getByte getShort getInt getLong getFloat getDouble getBigDecimal getString getObject	Integer	setByte setShort setInt setLong setFloat setDouble setBigDecimal setString setObject	Byte Short Integer Long Float Double BigDecimal String
INTEGER	INTEGER	getByte getShort getInt getLong getFloat getDouble getBigDecimal getString getObject	Integer	setByte setShort setInt setLong setFloat setDouble setBigDecimal setString setObject	Byte Short Integer Long Float Double BigDecimal String
BIGINT	BIGINT	getByte getShort getInt getLong getFloat getDouble getBigDecimal getString getObject	Long	setByte setShort setInt setLong setFloat setDouble setBigDecimal setString setObject	Byte Short Integer Long Float Double BigDecimal String
FLOAT	FLOAT	getByte getShort getInt getLong getFloat getDouble getBigDecimal getString getObject	Double	setByte setShort setInt setLong setFloat setDouble setBigDecimal setString setObject	Byte Short Integer Long Float Double BigDecimal String
DECIMAL	DECIMAL	getByte getShort getInt getLong getFloat getDouble getBigDecimal getString getObject	BigDecimal	setByte setShort setInt setLong setFloat setDouble setBigDecimal setString setObject	Byte Short Integer Long Float Double BigDecimal String
CHAR	CHAR	getByte getShort getInt getLong getBigDecimal getString getDate getTime getTimestamp getAsciiStream getCharacterStream getObject	String	setByte setShort setInt setLong setBigDecimal setString setDate setTime setTimestamp setAsciiStream setCharacterStream setObject	Byte Short Integer Long BigDecimal String Date Time Timestamp
VARCHAR	VARCHAR	getByte getShort getInt getLong getBigDecimal getString getDate getTime getTimestamp getAsciiStream getCharacterStream getObject	String	setByte setShort setInt setLong setBigDecimal setString setDate setTime setTimestamp setAsciiStream setCharacterStream setObject	Byte Short Integer Long BigDecimal String Date Time Timestamp
BYTE	BINARY	getString getBytes getBinaryStream getObject	byte[]	setString setBytes setBinaryStream setObject	String byte[]
VARBYTE	VARBINARY	getString getBytes getBinaryStream getObject	byte[]	setString setBytes setBinaryStream setObject	String byte[]
DATE	DATE	getString getDate getTimestamp getObject	Date	setString setDate setTimestamp setObject	String Date Timestamp
TIME	TIME	getString getTime getTimestamp getObject	Time	setString setTime setTimestamp setObject	String Time Timestamp
TIMESTAMP	TIMESTAMP	getString getDate getTime getTimestamp getObject	Timestamp	setString setDate setTime setTimestamp setObject	String Date Time Timestamp
CLOB	CLOB	getAsciiStream getCharacterStream getClob getObject	Clob	setAsciiStream setCharacterStream setClob setObject	Clob
BLOB	BLOB	getBlob getObject	Blob	setBinaryStream setBlob setObject	Blob
Structured UDT	STRUCT	getObject	Struct	setObject	Struct

Support for accessing CLOB values with the ResultSet getAsciiStream and getCharacterStream methods was introduced in Teradata JDBC Driver version 13.00.00.23.