lightbulb_outline Please take our October 2018 developer survey. Start survey

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

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)

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)