Module java.sql
Package java.sql

# Class Types

java.lang.Object
java.sql.Types

public class Types extends Object

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

This class is never instantiated.

Since:
  1.1

## Field Summary

Fields
Modifier and Type
Field
Description
`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`.
`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`.
`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`.
`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`.
`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`.
`static final int`
`BOOLEAN`
The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type `BOOLEAN`.
`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`.
`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`.
`static final int`
`DATALINK`
The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type `DATALINK`.
`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`.
`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`.
`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`.
`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`.
`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`.
`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`.
`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`.
`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`.
`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`.
`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`.
`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`
`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`.
`static final int`
`NULL`
The constant in the Java programming language that identifies the generic SQL value `NULL`.
`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`.
`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`.
`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`.
`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`.
`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`.
`static final int`
`REF_CURSOR`
The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type `REF CURSOR`.
`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`
`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`.
`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`.
`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`.
`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`.
`static final int`
`TIME_WITH_TIMEZONE`
The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type `TIME WITH TIMEZONE`.
`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`.
`static final int`
`TIMESTAMP_WITH_TIMEZONE`
The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type `TIMESTAMP WITH TIMEZONE`.
`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`.
`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`.
`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`.

## Method Summary

### Methods declared in class java.lang.Object

`clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait`

## Field Details

### BIT

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`.

See Also:
  - Constant Field Values

### TINYINT

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`.

See Also:
  - Constant Field Values

### SMALLINT

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`.

See Also:
  - Constant Field Values

### INTEGER

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`.

See Also:
  - Constant Field Values

### BIGINT

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`.

See Also:
  - Constant Field Values

### FLOAT

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`.

See Also:
  - Constant Field Values

### REAL

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`.

See Also:
  - Constant Field Values

### DOUBLE

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`.

See Also:
  - Constant Field Values

### NUMERIC

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`.

See Also:
  - Constant Field Values

### DECIMAL

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`.

See Also:
  - Constant Field Values

### CHAR

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`.

See Also:
  - Constant Field Values

### VARCHAR

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`.

See Also:
  - Constant Field Values

### LONGVARCHAR

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`.

See Also:
  - Constant Field Values

### DATE

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`.

See Also:
  - Constant Field Values

### TIME

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`.

See Also:
  - Constant Field Values

### TIMESTAMP

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`.

See Also:
  - Constant Field Values

### BINARY

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`.

See Also:
  - Constant Field Values

### VARBINARY

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`.

See Also:
  - Constant Field Values

### LONGVARBINARY

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`.

See Also:
  - Constant Field Values

### NULL

public static final int NULL

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

See Also:
  - Constant Field Values

### OTHER

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`.

See Also:
  - Constant Field Values

### JAVA_OBJECT

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`.

Since:
  1.2
See Also:
  - Constant Field Values

### DISTINCT

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`.

Since:
  1.2
See Also:
  - Constant Field Values

### STRUCT

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`.

Since:
  1.2
See Also:
  - Constant Field Values

### ARRAY

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`.

Since:
  1.2
See Also:
  - Constant Field Values

### BLOB

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`.

Since:
  1.2
See Also:
  - Constant Field Values

### CLOB

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`.

Since:
  1.2
See Also:
  - Constant Field Values

### REF

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`.

Since:
  1.2
See Also:
  - Constant Field Values

### DATALINK

public static final int DATALINK
The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type `DATALINK`.

Since:
  1.4
See Also:
  - Constant Field Values

### BOOLEAN

public static final int BOOLEAN
The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type `BOOLEAN`.

Since:
  1.4
See Also:
  - Constant Field Values

### ROWID

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`

Since:
  1.6
See Also:
  - Constant Field Values

### NCHAR

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`

Since:
  1.6
See Also:
  - Constant Field Values

### NVARCHAR

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`.

Since:
  1.6
See Also:
  - Constant Field Values

### LONGNVARCHAR

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`.

Since:
  1.6
See Also:
  - Constant Field Values

### NCLOB

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`.

Since:
  1.6
See Also:
  - Constant Field Values

### SQLXML

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`.

Since:
  1.6
See Also:
  - Constant Field Values

### REF_CURSOR

public static final int REF_CURSOR
The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type `REF CURSOR`.

Since:
  1.8
See Also:
  - Constant Field Values

### TIME_WITH_TIMEZONE

public static final int TIME_WITH_TIMEZONE
The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type `TIME WITH TIMEZONE`.

Since:
  1.8
See Also:
  - Constant Field Values

### TIMESTAMP_WITH_TIMEZONE

public static final int TIMESTAMP_WITH_TIMEZONE
The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type `TIMESTAMP WITH TIMEZONE`.

Since:
  1.8
See Also:
  - Constant Field Values