Added in API level 1

Summary: Constants | Inherited Methods

Types

public class Types
extends Object

java.lang.Object
↳	java.sql.Types

---

The class that defines the constants that are used to identify generic SQL types, called JDBC types.

This class is never instantiated.

Summary

Constants
int	ARRAY The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type ARRAY.
int	BIGINT The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type BIGINT.
int	BINARY The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type BINARY.
int	BIT The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type BIT.
int	BLOB The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type BLOB.
int	BOOLEAN The constant in the Java programming language, somtimes referred to as a type code, that identifies the generic SQL type BOOLEAN.
int	CHAR The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type CHAR.
int	CLOB The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type CLOB.
int	DATALINK The constant in the Java programming language, somtimes referred to as a type code, that identifies the generic SQL type DATALINK.
int	DATE The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type DATE.
int	DECIMAL The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type DECIMAL.
int	DISTINCT The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type DISTINCT.
int	DOUBLE The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type DOUBLE.
int	FLOAT The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type FLOAT.
int	INTEGER The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type INTEGER.
int	JAVA_OBJECT The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type JAVA_OBJECT.
int	LONGNVARCHAR The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type LONGNVARCHAR.
int	LONGVARBINARY The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type LONGVARBINARY.
int	LONGVARCHAR The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type LONGVARCHAR.
int	NCHAR The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type NCHAR
int	NCLOB The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type NCLOB.
int	NULL The constant in the Java programming language that identifies the generic SQL value NULL.
int	NUMERIC The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type NUMERIC.
int	NVARCHAR The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type NVARCHAR.
int	OTHER The constant in the Java programming language that indicates that the SQL type is database-specific and gets mapped to a Java object that can be accessed via the methods getObject and setObject.
int	REAL The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type REAL.
int	REF The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type REF.
int	ROWID The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type ROWID
int	SMALLINT The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type SMALLINT.
int	SQLXML The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type XML.
int	STRUCT The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type STRUCT.
int	TIME The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type TIME.
int	TIMESTAMP The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type TIMESTAMP.
int	TINYINT The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type TINYINT.
int	VARBINARY The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type VARBINARY.
int	VARCHAR The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type VARCHAR.

Inherited methods

From class java.lang.Object Object clone() Creates and returns a copy of this object. boolean equals(Object obj) Indicates whether some other object is "equal to" this one. void finalize() Called by the garbage collector on an object when garbage collection determines that there are no more references to the object. final Class<?> getClass() Returns the runtime class of this Object. int hashCode() Returns a hash code value for the object. final void notify() Wakes up a single thread that is waiting on this object's monitor. final void notifyAll() Wakes up all threads that are waiting on this object's monitor. String toString() Returns a string representation of the object. final void wait(long timeoutMillis, int nanos) Causes the current thread to wait until it is awakened, typically by being notified or interrupted, or until a certain amount of real time has elapsed. final void wait(long timeoutMillis) Causes the current thread to wait until it is awakened, typically by being notified or interrupted, or until a certain amount of real time has elapsed. final void wait() Causes the current thread to wait until it is awakened, typically by being notified or interrupted.

Constants

ARRAY

Added in API level 1

public static final int ARRAY

The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type ARRAY.

Constant Value: 2003 (0x000007d3)

BIGINT

Added in API level 1

public static final int BIGINT

The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type BIGINT.

Constant Value: -5 (0xfffffffb)

BINARY

Added in API level 1

public static final int BINARY

The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type BINARY.

Constant Value: -2 (0xfffffffe)

BIT

Added in API level 1

public static final int BIT

The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type BIT.

Constant Value: -7 (0xfffffff9)

BLOB

Added in API level 1

public static final int BLOB

The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type BLOB.

Constant Value: 2004 (0x000007d4)

BOOLEAN

Added in API level 1

public static final int BOOLEAN

The constant in the Java programming language, somtimes referred to as a type code, that identifies the generic SQL type BOOLEAN.

Constant Value: 16 (0x00000010)

CHAR

Added in API level 1

public static final int CHAR

The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type CHAR.

Constant Value: 1 (0x00000001)

CLOB

Added in API level 1

public static final int CLOB

The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type CLOB.

Constant Value: 2005 (0x000007d5)

DATALINK

Added in API level 1

public static final int DATALINK

The constant in the Java programming language, somtimes referred to as a type code, that identifies the generic SQL type DATALINK.

Constant Value: 70 (0x00000046)

DATE

Added in API level 1

public static final int DATE

The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type DATE.

Constant Value: 91 (0x0000005b)

DECIMAL

Added in API level 1

public static final int DECIMAL

The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type DECIMAL.

Constant Value: 3 (0x00000003)

DISTINCT

Added in API level 1

public static final int DISTINCT

The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type DISTINCT.

Constant Value: 2001 (0x000007d1)

DOUBLE

Added in API level 1

public static final int DOUBLE

The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type DOUBLE.

Constant Value: 8 (0x00000008)

FLOAT

Added in API level 1

public static final int FLOAT

The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type FLOAT.

Constant Value: 6 (0x00000006)

INTEGER

Added in API level 1

public static final int INTEGER

The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type INTEGER.

Constant Value: 4 (0x00000004)

JAVA_OBJECT

Added in API level 1

public static final int JAVA_OBJECT

The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type JAVA_OBJECT.

Constant Value: 2000 (0x000007d0)

LONGNVARCHAR

Added in API level 9

public static final int LONGNVARCHAR

The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type LONGNVARCHAR.

Constant Value: -16 (0xfffffff0)

LONGVARBINARY

Added in API level 1

public static final int LONGVARBINARY

The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type LONGVARBINARY.

Constant Value: -4 (0xfffffffc)

LONGVARCHAR

Added in API level 1

public static final int LONGVARCHAR

The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type LONGVARCHAR.

Constant Value: -1 (0xffffffff)

NCHAR

Added in API level 9

public static final int NCHAR

The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type NCHAR

Constant Value: -15 (0xfffffff1)

NCLOB

Added in API level 9

public static final int NCLOB

The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type NCLOB.

Constant Value: 2011 (0x000007db)

NULL

Added in API level 1

public static final int NULL

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

Constant Value: 0 (0x00000000)

NUMERIC

Added in API level 1

public static final int NUMERIC

The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type NUMERIC.

Constant Value: 2 (0x00000002)

NVARCHAR

Added in API level 9

public static final int NVARCHAR

The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type NVARCHAR.

Constant Value: -9 (0xfffffff7)

OTHER

Added in API level 1

public static final int OTHER

The constant in the Java programming language that indicates that the SQL type is database-specific and gets mapped to a Java object that can be accessed via the methods getObject and setObject.

Constant Value: 1111 (0x00000457)

REAL

Added in API level 1

public static final int REAL

The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type REAL.

Constant Value: 7 (0x00000007)

REF

Added in API level 1

public static final int REF

The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type REF.

Constant Value: 2006 (0x000007d6)

ROWID

Added in API level 9

public static final int ROWID

The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type ROWID

Constant Value: -8 (0xfffffff8)

SMALLINT

Added in API level 1

public static final int SMALLINT

The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type SMALLINT.

Constant Value: 5 (0x00000005)

SQLXML

Added in API level 9

public static final int SQLXML

The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type XML.

Constant Value: 2009 (0x000007d9)

STRUCT

Added in API level 1

public static final int STRUCT

The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type STRUCT.

Constant Value: 2002 (0x000007d2)

TIME

Added in API level 1

public static final int TIME

The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type TIME.

Constant Value: 92 (0x0000005c)

TIMESTAMP

Added in API level 1

public static final int TIMESTAMP

The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type TIMESTAMP.

Constant Value: 93 (0x0000005d)

TINYINT

Added in API level 1

public static final int TINYINT

The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type TINYINT.

Constant Value: -6 (0xfffffffa)

VARBINARY

Added in API level 1

public static final int VARBINARY

The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type VARBINARY.

Constant Value: -3 (0xfffffffd)

VARCHAR

Added in API level 1

public static final int VARCHAR

The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type VARCHAR.

Constant Value: 12 (0x0000000c)