Skip to content

Most visited

Recently visited

navigation
Added in API level 1

Types

public class Types
extends Object

java.lang.Object
   ↳ java.sql.Types


A class which defines constants used to identify generic SQL types, also called JDBC types. The type constant values are equivalent to those defined by X/OPEN.

Summary

Constants

int ARRAY

The type code that identifies the SQL type ARRAY.

int BIGINT

The type code that identifies the SQL type BIGINT.

int BINARY

The type code that identifies the SQL type BINARY.

int BIT

The type code that identifies the SQL type BIT.

int BLOB

The type code that identifies the SQL type BLOB.

int BOOLEAN

The type code that identifies the SQL type BOOLEAN.

int CHAR

The type code that identifies the SQL type CHAR.

int CLOB

The type code that identifies the SQL type CLOB.

int DATALINK

The type code that identifies the SQL type DATALINK.

int DATE

The type code that identifies the SQL type DATE.

int DECIMAL

The type code that identifies the SQL type DECIMAL.

int DISTINCT

The type code that identifies the SQL type DISTINCT.

int DOUBLE

The type code that identifies the SQL type DOUBLE.

int FLOAT

The type code that identifies the SQL type FLOAT.

int INTEGER

The type code that identifies the SQL type INTEGER.

int JAVA_OBJECT

The type code that identifies the SQL type JAVA_OBJECT.

int LONGNVARCHAR

The type code that identifies the SQL type LONGNVARCHAR.

int LONGVARBINARY

The type code that identifies the SQL type LONGVARBINARY.

int LONGVARCHAR

The type code that identifies the SQL type LONGVARCHAR.

int NCHAR

The type code that identifies the SQL type NCHAR.

int NCLOB

The type code that identifies the SQL type NCLOB.

int NULL

The type code that identifies the SQL type NULL.

int NUMERIC

The type code that identifies the SQL type NUMERIC.

int NVARCHAR

The type code that identifies the SQL type NVARCHAR.

int OTHER

The type code that identifies that the SQL type is database specific and is mapped to a Java object, accessed via the methods getObject and setObject.

int REAL

The type code that identifies the SQL type REAL.

int REF

The type code that identifies the SQL type REF.

int ROWID

The type code that identifies the SQL type ROWID.

int SMALLINT

The type code that identifies the SQL type SMALLINT.

int SQLXML

The type code that identifies the SQL type SQLXML.

int STRUCT

The type code that identifies the SQL type STRUCT.

int TIME

The type code that identifies the SQL type TIME.

int TIMESTAMP

The type code that identifies the SQL type TIMESTAMP.

int TINYINT

The type code that identifies the SQL type TINYINT.

int VARBINARY

The type code that identifies the SQL type VARBINARY.

int VARCHAR

The type code that identifies the SQL type VARCHAR.

Inherited methods

From class java.lang.Object

Constants

ARRAY

Added in API level 1
int ARRAY

The type code that identifies the SQL type ARRAY.

Constant Value: 2003 (0x000007d3)

BIGINT

Added in API level 1
int BIGINT

The type code that identifies the SQL type BIGINT.

Constant Value: -5 (0xfffffffb)

BINARY

Added in API level 1
int BINARY

The type code that identifies the SQL type BINARY.

Constant Value: -2 (0xfffffffe)

BIT

Added in API level 1
int BIT

The type code that identifies the SQL type BIT.

Constant Value: -7 (0xfffffff9)

BLOB

Added in API level 1
int BLOB

The type code that identifies the SQL type BLOB.

Constant Value: 2004 (0x000007d4)

BOOLEAN

Added in API level 1
int BOOLEAN

The type code that identifies the SQL type BOOLEAN.

Constant Value: 16 (0x00000010)

CHAR

Added in API level 1
int CHAR

The type code that identifies the SQL type CHAR.

Constant Value: 1 (0x00000001)

CLOB

Added in API level 1
int CLOB

The type code that identifies the SQL type CLOB.

Constant Value: 2005 (0x000007d5)

DATALINK

Added in API level 1
int DATALINK

The type code that identifies the SQL type DATALINK.

Constant Value: 70 (0x00000046)

DATE

Added in API level 1
int DATE

The type code that identifies the SQL type DATE.

Constant Value: 91 (0x0000005b)

DECIMAL

Added in API level 1
int DECIMAL

The type code that identifies the SQL type DECIMAL.

Constant Value: 3 (0x00000003)

DISTINCT

Added in API level 1
int DISTINCT

The type code that identifies the SQL type DISTINCT.

Constant Value: 2001 (0x000007d1)

DOUBLE

Added in API level 1
int DOUBLE

The type code that identifies the SQL type DOUBLE.

Constant Value: 8 (0x00000008)

FLOAT

Added in API level 1
int FLOAT

The type code that identifies the SQL type FLOAT.

Constant Value: 6 (0x00000006)

INTEGER

Added in API level 1
int INTEGER

The type code that identifies the SQL type INTEGER.

Constant Value: 4 (0x00000004)

JAVA_OBJECT

Added in API level 1
int JAVA_OBJECT

The type code that identifies the SQL type JAVA_OBJECT.

Constant Value: 2000 (0x000007d0)

LONGNVARCHAR

Added in API level 9
int LONGNVARCHAR

The type code that identifies the SQL type LONGNVARCHAR.

Constant Value: -16 (0xfffffff0)

LONGVARBINARY

Added in API level 1
int LONGVARBINARY

The type code that identifies the SQL type LONGVARBINARY.

Constant Value: -4 (0xfffffffc)

LONGVARCHAR

Added in API level 1
int LONGVARCHAR

The type code that identifies the SQL type LONGVARCHAR.

Constant Value: -1 (0xffffffff)

NCHAR

Added in API level 9
int NCHAR

The type code that identifies the SQL type NCHAR.

Constant Value: -15 (0xfffffff1)

NCLOB

Added in API level 9
int NCLOB

The type code that identifies the SQL type NCLOB.

Constant Value: 2011 (0x000007db)

NULL

Added in API level 1
int NULL

The type code that identifies the SQL type NULL.

Constant Value: 0 (0x00000000)

NUMERIC

Added in API level 1
int NUMERIC

The type code that identifies the SQL type NUMERIC.

Constant Value: 2 (0x00000002)

NVARCHAR

Added in API level 9
int NVARCHAR

The type code that identifies the SQL type NVARCHAR.

Constant Value: -9 (0xfffffff7)

OTHER

Added in API level 1
int OTHER

The type code that identifies that the SQL type is database specific and is mapped to a Java object, accessed via the methods getObject and setObject.

Constant Value: 1111 (0x00000457)

REAL

Added in API level 1
int REAL

The type code that identifies the SQL type REAL.

Constant Value: 7 (0x00000007)

REF

Added in API level 1
int REF

The type code that identifies the SQL type REF.

Constant Value: 2006 (0x000007d6)

ROWID

Added in API level 9
int ROWID

The type code that identifies the SQL type ROWID.

Constant Value: -8 (0xfffffff8)

SMALLINT

Added in API level 1
int SMALLINT

The type code that identifies the SQL type SMALLINT.

Constant Value: 5 (0x00000005)

SQLXML

Added in API level 9
int SQLXML

The type code that identifies the SQL type SQLXML.

Constant Value: 2009 (0x000007d9)

STRUCT

Added in API level 1
int STRUCT

The type code that identifies the SQL type STRUCT.

Constant Value: 2002 (0x000007d2)

TIME

Added in API level 1
int TIME

The type code that identifies the SQL type TIME.

Constant Value: 92 (0x0000005c)

TIMESTAMP

Added in API level 1
int TIMESTAMP

The type code that identifies the SQL type TIMESTAMP.

Constant Value: 93 (0x0000005d)

TINYINT

Added in API level 1
int TINYINT

The type code that identifies the SQL type TINYINT.

Constant Value: -6 (0xfffffffa)

VARBINARY

Added in API level 1
int VARBINARY

The type code that identifies the SQL type VARBINARY.

Constant Value: -3 (0xfffffffd)

VARCHAR

Added in API level 1
int VARCHAR

The type code that identifies the 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.