```
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 and 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`	`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`	`TIMESTAMP` The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type `TIMESTAMP`.
`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`.

Types (Java Platform SE 7 ) Home of API Java Contents Haut

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

Document created the 11/06/2005, last modified the 04/03/2020
Source of the printed document:https://www.gaudry.be/en/java-api-rf-java/sql/types.html

The infobrol is a personal site whose content is my sole responsibility. The text is available under CreativeCommons license (BY-NC-SA). More info on the terms of use and the author.

References

Manuel PHP : https://docs.oracle.com

These references and links indicate documents consulted during the writing of this page, or which may provide additional information, but the authors of these sources can not be held responsible for the content of this page.
The author This site is solely responsible for the way in which the various concepts, and the freedoms that are taken with the reference works, are presented here. Remember that you must cross multiple source information to reduce the risk of errors.

Contents Haut

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

References