Skip to content

Most visited

Recently visited

navigation

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

Constants

ARRAY

Added in API level 1
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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)

This site uses cookies to store your preferences for site-specific language and display options.

Hooray!

This class requires API level or higher

This doc is hidden because your selected API level for the documentation is . You can change the documentation API level with the selector above the left navigation.

For more information about specifying the API level your app requires, read Supporting Different Platform Versions.