public class

Types

extends Object
java.lang.Object
   ↳java.sql.Types

Class Overview

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
intARRAYThe type code that identifies the SQL type ARRAY.
intBIGINTThe type code that identifies the SQL type BIGINT.
intBINARYThe type code that identifies the SQL type BINARY.
intBITThe type code that identifies the SQL type BIT.
intBLOBThe type code that identifies the SQL type BLOB.
intBOOLEANThe type code that identifies the SQL type BOOLEAN.
intCHARThe type code that identifies the SQL type CHAR.
intCLOBThe type code that identifies the SQL type CLOB.
intDATALINKThe type code that identifies the SQL type DATALINK.
intDATEThe type code that identifies the SQL type DATE.
intDECIMALThe type code that identifies the SQL type DECIMAL.
intDISTINCTThe type code that identifies the SQL type DISTINCT.
intDOUBLEThe type code that identifies the SQL type DOUBLE.
intFLOATThe type code that identifies the SQL type FLOAT.
intINTEGERThe type code that identifies the SQL type INTEGER.
intJAVA_OBJECTThe type code that identifies the SQL type JAVA_OBJECT.
intLONGNVARCHARThe type code that identifies the SQL type LONGNVARCHAR.
intLONGVARBINARYThe type code that identifies the SQL type LONGVARBINARY.
intLONGVARCHARThe type code that identifies the SQL type LONGVARCHAR.
intNCHARThe type code that identifies the SQL type NCHAR.
intNCLOBThe type code that identifies the SQL type NCLOB.
intNULLThe type code that identifies the SQL type NULL.
intNUMERICThe type code that identifies the SQL type NUMERIC.
intNVARCHARThe type code that identifies the SQL type NVARCHAR.
intOTHERThe 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.
intREALThe type code that identifies the SQL type REAL.
intREFThe type code that identifies the SQL type REF.
intROWIDThe type code that identifies the SQL type ROWID.
intSMALLINTThe type code that identifies the SQL type SMALLINT.
intSQLXMLThe type code that identifies the SQL type SQLXML.
intSTRUCTThe type code that identifies the SQL type STRUCT.
intTIMEThe type code that identifies the SQL type TIME.
intTIMESTAMPThe type code that identifies the SQL type TIMESTAMP.
intTINYINTThe type code that identifies the SQL type TINYINT.
intVARBINARYThe type code that identifies the SQL type VARBINARY.
intVARCHARThe type code that identifies the SQL type VARCHAR.
[Expand]
Inherited Methods
From class java.lang.Object

Constants

public static final int ARRAY

Since: API Level 1

The type code that identifies the SQL type ARRAY.

Constant Value: 2003 (0x000007d3)

public static final int BIGINT

Since: API Level 1

The type code that identifies the SQL type BIGINT.

Constant Value: -5 (0xfffffffb)

public static final int BINARY

Since: API Level 1

The type code that identifies the SQL type BINARY.

Constant Value: -2 (0xfffffffe)

public static final int BIT

Since: API Level 1

The type code that identifies the SQL type BIT.

Constant Value: -7 (0xfffffff9)

public static final int BLOB

Since: API Level 1

The type code that identifies the SQL type BLOB.

Constant Value: 2004 (0x000007d4)

public static final int BOOLEAN

Since: API Level 1

The type code that identifies the SQL type BOOLEAN.

Constant Value: 16 (0x00000010)

public static final int CHAR

Since: API Level 1

The type code that identifies the SQL type CHAR.

Constant Value: 1 (0x00000001)

public static final int CLOB

Since: API Level 1

The type code that identifies the SQL type CLOB.

Constant Value: 2005 (0x000007d5)

public static final int DATALINK

Since: API Level 1

The type code that identifies the SQL type DATALINK.

Constant Value: 70 (0x00000046)

public static final int DATE

Since: API Level 1

The type code that identifies the SQL type DATE.

Constant Value: 91 (0x0000005b)

public static final int DECIMAL

Since: API Level 1

The type code that identifies the SQL type DECIMAL.

Constant Value: 3 (0x00000003)

public static final int DISTINCT

Since: API Level 1

The type code that identifies the SQL type DISTINCT.

Constant Value: 2001 (0x000007d1)

public static final int DOUBLE

Since: API Level 1

The type code that identifies the SQL type DOUBLE.

Constant Value: 8 (0x00000008)

public static final int FLOAT

Since: API Level 1

The type code that identifies the SQL type FLOAT.

Constant Value: 6 (0x00000006)

public static final int INTEGER

Since: API Level 1

The type code that identifies the SQL type INTEGER.

Constant Value: 4 (0x00000004)

public static final int JAVA_OBJECT

Since: API Level 1

The type code that identifies the SQL type JAVA_OBJECT.

Constant Value: 2000 (0x000007d0)

public static final int LONGNVARCHAR

Since: API Level 9

The type code that identifies the SQL type LONGNVARCHAR.

Constant Value: -16 (0xfffffff0)

public static final int LONGVARBINARY

Since: API Level 1

The type code that identifies the SQL type LONGVARBINARY.

Constant Value: -4 (0xfffffffc)

public static final int LONGVARCHAR

Since: API Level 1

The type code that identifies the SQL type LONGVARCHAR.

Constant Value: -1 (0xffffffff)

public static final int NCHAR

Since: API Level 9

The type code that identifies the SQL type NCHAR.

Constant Value: -15 (0xfffffff1)

public static final int NCLOB

Since: API Level 9

The type code that identifies the SQL type NCLOB.

Constant Value: 2011 (0x000007db)

public static final int NULL

Since: API Level 1

The type code that identifies the SQL type NULL.

Constant Value: 0 (0x00000000)

public static final int NUMERIC

Since: API Level 1

The type code that identifies the SQL type NUMERIC.

Constant Value: 2 (0x00000002)

public static final int NVARCHAR

Since: API Level 9

The type code that identifies the SQL type NVARCHAR.

Constant Value: -9 (0xfffffff7)

public static final int OTHER

Since: API Level 1

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)

public static final int REAL

Since: API Level 1

The type code that identifies the SQL type REAL.

Constant Value: 7 (0x00000007)

public static final int REF

Since: API Level 1

The type code that identifies the SQL type REF.

Constant Value: 2006 (0x000007d6)

public static final int ROWID

Since: API Level 9

The type code that identifies the SQL type ROWID.

Constant Value: -8 (0xfffffff8)

public static final int SMALLINT

Since: API Level 1

The type code that identifies the SQL type SMALLINT.

Constant Value: 5 (0x00000005)

public static final int SQLXML

Since: API Level 9

The type code that identifies the SQL type SQLXML.

Constant Value: 2009 (0x000007d9)

public static final int STRUCT

Since: API Level 1

The type code that identifies the SQL type STRUCT.

Constant Value: 2002 (0x000007d2)

public static final int TIME

Since: API Level 1

The type code that identifies the SQL type TIME.

Constant Value: 92 (0x0000005c)

public static final int TIMESTAMP

Since: API Level 1

The type code that identifies the SQL type TIMESTAMP.

Constant Value: 93 (0x0000005d)

public static final int TINYINT

Since: API Level 1

The type code that identifies the SQL type TINYINT.

Constant Value: -6 (0xfffffffa)

public static final int VARBINARY

Since: API Level 1

The type code that identifies the SQL type VARBINARY.

Constant Value: -3 (0xfffffffd)

public static final int VARCHAR

Since: API Level 1

The type code that identifies the SQL type VARCHAR.

Constant Value: 12 (0x0000000c)