Types (Java Platform SE 8 )

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.

Field Summary

Fields
Modifier and Type	Field	Description
`static int`	`ARRAY`	The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type `ARRAY`.
`static int`	`BIGINT`	The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type `BIGINT`.
`static int`	`BINARY`	The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type `BINARY`.
`static int`	`BIT`	The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type `BIT`.
`static int`	`BLOB`	The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type `BLOB`.
`static int`	`BOOLEAN`	The constant in the Java programming language, somtimes referred to as a type code, that identifies the generic SQL type `BOOLEAN`.
`static int`	`CHAR`	The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type `CHAR`.
`static int`	`CLOB`	The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type `CLOB`.
`static int`	`DATALINK`	The constant in the Java programming language, somtimes referred to as a type code, that identifies the generic SQL type `DATALINK`.
`static int`	`DATE`	The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type `DATE`.
`static int`	`DECIMAL`	The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type `DECIMAL`.
`static int`	`DISTINCT`	The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type `DISTINCT`.
`static int`	`DOUBLE`	The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type `DOUBLE`.
`static int`	`FLOAT`	The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type `FLOAT`.
`static int`	`INTEGER`	The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type `INTEGER`.
`static 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 int`	`LONGNVARCHAR`	The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type `LONGNVARCHAR`.
`static int`	`LONGVARBINARY`	The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type `LONGVARBINARY`.
`static int`	`LONGVARCHAR`	The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type `LONGVARCHAR`.
`static int`	`NCHAR`	The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type `NCHAR`
`static int`	`NCLOB`	The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type `NCLOB`.
`static int`	`NULL`	The constant in the Java programming language that identifies the generic SQL value `NULL`.
`static int`	`NUMERIC`	The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type `NUMERIC`.
`static int`	`NVARCHAR`	The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type `NVARCHAR`.
`static 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 int`	`REAL`	The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type `REAL`.
`static int`	`REF`	The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type `REF`.
`static 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 int`	`ROWID`	The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type `ROWID`
`static int`	`SMALLINT`	The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type `SMALLINT`.
`static int`	`SQLXML`	The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type `XML`.
`static int`	`STRUCT`	The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type `STRUCT`.
`static int`	`TIME`	The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type `TIME`.
`static 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 int`	`TIMESTAMP`	The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type `TIMESTAMP`.
`static 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 int`	`TINYINT`	The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type `TINYINT`.
`static int`	`VARBINARY`	The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type `VARBINARY`.
`static 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 inherited from class java.lang.Object
  clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

- Field Detail
  - 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, somtimes 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, somtimes 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

Submit a bug or feature
For further API reference and developer documentation, see Java SE Documentation. That documentation contains more detailed, developer-targeted descriptions, with conceptual overviews, definitions of terms, workarounds, and working code examples.
Copyright © 1993, 2025, Oracle and/or its affiliates. All rights reserved. Use is subject to license terms. Also see the documentation redistribution policy.

Class Types

Field Summary

Method Summary

Methods inherited from class java.lang.Object

Field Detail

BIT

TINYINT

SMALLINT

INTEGER

BIGINT

FLOAT

REAL

DOUBLE

NUMERIC

DECIMAL

CHAR

VARCHAR

LONGVARCHAR

DATE

TIME

TIMESTAMP

BINARY

VARBINARY

LONGVARBINARY

NULL

OTHER

JAVA_OBJECT

DISTINCT

STRUCT

ARRAY

BLOB

CLOB

REF

DATALINK

BOOLEAN

ROWID

NCHAR

NVARCHAR

LONGNVARCHAR

NCLOB

SQLXML

REF_CURSOR

TIME_WITH_TIMEZONE

TIMESTAMP_WITH_TIMEZONE