SqlType

Values

ValueMeaning
BIGINT

sometimes referred to as a type code, that identifies the generic SQL type BIGINT.

BIT

sometimes referred to as a type code, that identifies the generic SQL type BINARY.

BLOB

sometimes referred to as a type code, that identifies the generic SQL type BLOB.

BOOLEAN

somtimes referred to as a type code, that identifies the generic SQL type BOOLEAN.

CHAR

sometimes referred to as a type code, that identifies the generic SQL type CHAR.

CLOB

sometimes referred to as a type code, that identifies the generic SQL type CLOB.

DATE

sometimes referred to as a type code, that identifies the generic SQL type DATE.

DATETIME

sometimes referred to as a type code, that identifies the generic SQL type DATETIME.

DECIMAL

sometimes referred to as a type code, that identifies the generic SQL type DECIMAL.

DOUBLE

sometimes referred to as a type code, that identifies the generic SQL type DOUBLE.

FLOAT

sometimes referred to as a type code, that identifies the generic SQL type FLOAT.

INTEGER

sometimes referred to as a type code, that identifies the generic SQL type INTEGER.

LONGNVARCHAR

sometimes referred to as a type code, that identifies the generic SQL type LONGNVARCHAR.

LONGVARBINARY

sometimes referred to as a type code, that identifies the generic SQL type LONGVARBINARY.

LONGVARCHAR

sometimes referred to as a type code, that identifies the generic SQL type LONGVARCHAR.

NCHAR

sometimes referred to as a type code, that identifies the generic SQL type NCHAR

NCLOB

sometimes referred to as a type code, that identifies the generic SQL type NCLOB.

NULL

The constant in the Java programming language that identifies the generic SQL value NULL.

NUMERIC

sometimes referred to as a type code, that identifies the generic SQL type NUMERIC.

NVARCHAR

sometimes referred to as a type code, that identifies the generic SQL type NVARCHAR.

OTHER

indicates that the SQL type is database-specific and gets mapped to a object that can be accessed via the methods getObject and setObject.

SMALLINT

sometimes referred to as a type code, that identifies the generic SQL type SMALLINT.

TIME

sometimes referred to as a type code, that identifies the generic SQL type TIME.

TINYINT

sometimes referred to as a type code, that identifies the generic SQL type TINYINT.

VARBINARY

sometimes referred to as a type code, that identifies the generic SQL type VARBINARY.

VARCHAR

sometimes referred to as a type code, that identifies the generic SQL type VARCHAR.

Meta