Class Types

public class Types extends Object

The SQL types constants and their values are defined in this class. The constant values are equivalent to those defined by XOPEN.

Fields

The following attributes are all static final integer values. It’s quite handy to use these attribute names in Java programs instead of the integer values; it makes the code much more readable and portable.

ARRAY

public static final int ARRAY = 2003

BIGINT

public static final int BIGINT = -5

BINARY

public static final int BINARY = -2

BIT

public static final int BIT = -7

BLOB

public static final int BLOB = 2004

BOOLEAN

public static final int BOOLEAN = 16 

CHAR

public static final int CHAR = 1

CLOB

public static final int CLOB = 2005

DATALINK

public static final int DATALINK = 70

DATE

public static final int DATE = 91

DECIMAL

public static final int DECIMAL = 3

DISTINCT

public static final int DISTINCT = 2001

DOUBLE

public static final int DOUBLE = 8

FLOAT

public static final int FLOAT = 6

INTEGER

public static final int INTEGER = 4

JAVA_OBJECT

public static final int JAVA_OBJECT = 2000

LONGVARCHAR

public static final int LONGVARCHAR = -4 

LONGVARBINARY

public static final int LONGVARBINARY = -1

NULL

public static final int NULL = 0

NUMERIC

public static final int NUMERIC = 2

OTHER

public static final int OTHER = 1111

REAL

public static final int REAL = 7

REF

public static final int REF = 2006

SMALLINT

public static final int SMALLINT = 5

STRUCT

public static final int STRUCT = 2002

TIME

public static final int TIME = 92

TIMESTAMP

public static final int TIMESTAMP = 93

TINYINT

public static final int TINYINT = -6 

VARBINARY

public static final int VARBINARY = -3

VARCHAR

public static final int VARCHAR = 12