SQLDataType (jOOQ 3.9.6 API)

java.lang.Object
- org.jooq.impl.SQLDataType

```
public final class SQLDataType
extends Object
```
The SQL standard data types, as described in Types.
These types are usually the ones that are referenced by generated source code. Most RDBMS have an almost 1:1 mapping between their vendor-specific types and the ones in this class (except Oracle). Some RDBMS also have extensions, e.g. for geospacial data types. See the dialect-specific data type classes for more information.

Author:

Lukas Eder

Field Summary

Fields
Modifier and Type	Field and Description
`static DataType<Long>`	`BIGINT` The `Types.BIGINT` type.
`static DataType<ULong>`	`BIGINTUNSIGNED` The unsigned `Types.BIGINT` type.
`static DataType<byte[]>`	`BINARY` The `Types.BINARY` type.
`static DataType<Boolean>`	`BIT` The `Types.BIT` type.
`static DataType<byte[]>`	`BLOB` The `Types.BLOB` type.
`static DataType<Boolean>`	`BOOLEAN` The `Types.BOOLEAN` type.
`static DataType<String>`	`CHAR` The `Types.CHAR` type.
`static DataType<String>`	`CLOB` The `Types.CLOB` type.
`static DataType<Date>`	`DATE` The `Types.DATE` type.
`static DataType<BigDecimal>`	`DECIMAL` The `Types.DECIMAL` type.
`static DataType<BigInteger>`	`DECIMAL_INTEGER` The zero-scale `Types.DECIMAL` type.
`static DataType<Double>`	`DOUBLE` The `Types.DOUBLE` type.
`static DataType<Double>`	`FLOAT` The `Types.FLOAT` type.
`static DataType<Integer>`	`INTEGER` The `Types.INTEGER` type.
`static DataType<UInteger>`	`INTEGERUNSIGNED` The unsigned `Types.INTEGER` type.
`static DataType<DayToSecond>`	`INTERVALDAYTOSECOND` The SQL standard `INTERVAL DAY TO SECOND` data type.
`static DataType<YearToMonth>`	`INTERVALYEARTOMONTH` The SQL standard `INTERVAL YEAR TO MONTH` data type.
`static DataType<java.time.LocalDate>`	`LOCALDATE` The `Types.DATE` type.
`static DataType<java.time.LocalDateTime>`	`LOCALDATETIME` The `Types.TIMESTAMP` type.
`static DataType<java.time.LocalTime>`	`LOCALTIME` The `Types.TIME` type.
`static DataType<String>`	`LONGNVARCHAR` The `Types.LONGNVARCHAR` type.
`static DataType<byte[]>`	`LONGVARBINARY` The `Types.LONGVARBINARY` type.
`static DataType<String>`	`LONGVARCHAR` The `Types.LONGVARCHAR` type.
`static DataType<String>`	`NCHAR` The `Types.NCHAR` type.
`static DataType<String>`	`NCLOB` The `Types.NCLOB` type.
`static DataType<BigDecimal>`	`NUMERIC` The `Types.NUMERIC` type.
`static DataType<String>`	`NVARCHAR` The `Types.NVARCHAR` type.
`static DataType<java.time.OffsetDateTime>`	`OFFSETDATETIME` The `Types.TIMESTAMP_WITH_TIMEZONE` type.
`static DataType<java.time.OffsetTime>`	`OFFSETTIME` The `Types.TIME_WITH_TIMEZONE` type.
`static DataType<Object>`	`OTHER` The `Types.OTHER` type.
`static DataType<Float>`	`REAL` The `Types.REAL` type.
`static DataType<Record>`	`RECORD` The `Types.STRUCT` type.
`static DataType<Result<Record>>`	`RESULT` The `ResultSet` type.
`static DataType<Short>`	`SMALLINT` The `Types.SMALLINT` type.
`static DataType<UShort>`	`SMALLINTUNSIGNED` The unsigned `Types.SMALLINT` type.
`static DataType<Time>`	`TIME` The `Types.TIME` type.
`static DataType<Timestamp>`	`TIMESTAMP` The `Types.TIMESTAMP` type.
`static DataType<java.time.OffsetDateTime>`	`TIMESTAMPWITHTIMEZONE` The `Types.TIMESTAMP_WITH_TIMEZONE` type.
`static DataType<java.time.OffsetTime>`	`TIMEWITHTIMEZONE` The `Types.TIME_WITH_TIMEZONE` type.
`static DataType<Byte>`	`TINYINT` The `Types.TINYINT` type.
`static DataType<UByte>`	`TINYINTUNSIGNED` The unsigned `Types.TINYINT` type.
`static DataType<UUID>`	`UUID` The `UUID` type.
`static DataType<byte[]>`	`VARBINARY` The `Types.VARBINARY` type.
`static DataType<String>`	`VARCHAR` The `Types.VARCHAR` type.

Method Summary

All Methods Static Methods Concrete Methods
Modifier and Type	Method and Description
`static DataType<byte[]>`	`BINARY(int length)` The `Types.BINARY` type.
`static DataType<byte[]>`	`BLOB(int length)` The `Types.BLOB` type.
`static DataType<String>`	`CHAR(int length)` The `Types.CHAR` type.
`static DataType<String>`	`CLOB(int length)` The `Types.CLOB` type.
`static DataType<BigDecimal>`	`DECIMAL(int precision)` The `Types.DECIMAL` type.
`static DataType<BigDecimal>`	`DECIMAL(int precision, int scale)` The `Types.DECIMAL` type.
`static DataType<String>`	`LONGNVARCHAR(int length)` The `Types.LONGNVARCHAR` type.
`static DataType<byte[]>`	`LONGVARBINARY(int length)` The `Types.LONGVARBINARY` type.
`static DataType<String>`	`LONGVARCHAR(int length)` The `Types.LONGVARCHAR` type.
`static DataType<String>`	`NCHAR(int length)` The `Types.NCHAR` type.
`static DataType<String>`	`NCLOB(int length)` The `Types.NCLOB` type.
`static DataType<BigDecimal>`	`NUMERIC(int precision)` The `Types.NUMERIC` type.
`static DataType<BigDecimal>`	`NUMERIC(int precision, int scale)` The `Types.NUMERIC` type.
`static DataType<String>`	`NVARCHAR(int length)` The `Types.NVARCHAR` type.
`static DataType<byte[]>`	`VARBINARY(int length)` The `Types.VARBINARY` type.
`static DataType<String>`	`VARCHAR(int length)` The `Types.VARCHAR` type.

Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Field Detail
- VARCHAR
```
public static final DataType<String> VARCHAR
```
  The Types.VARCHAR type.
- CHAR
```
public static final DataType<String> CHAR
```
  The Types.CHAR type.
- LONGVARCHAR
```
public static final DataType<String> LONGVARCHAR
```
  The Types.LONGVARCHAR type.
- CLOB
```
public static final DataType<String> CLOB
```
  The Types.CLOB type.
- NVARCHAR
```
public static final DataType<String> NVARCHAR
```
  The Types.NVARCHAR type.
- NCHAR
```
public static final DataType<String> NCHAR
```
  The Types.NCHAR type.
- LONGNVARCHAR
```
public static final DataType<String> LONGNVARCHAR
```
  The Types.LONGNVARCHAR type.
- NCLOB
```
public static final DataType<String> NCLOB
```
  The Types.NCLOB type.
- BOOLEAN
```
public static final DataType<Boolean> BOOLEAN
```
  The Types.BOOLEAN type.
- BIT
```
public static final DataType<Boolean> BIT
```
  The Types.BIT type.
- TINYINT
```
public static final DataType<Byte> TINYINT
```
  The Types.TINYINT type.
- SMALLINT
```
public static final DataType<Short> SMALLINT
```
  The Types.SMALLINT type.
- INTEGER
```
public static final DataType<Integer> INTEGER
```
  The Types.INTEGER type.
- BIGINT
```
public static final DataType<Long> BIGINT
```
  The Types.BIGINT type.
- DECIMAL_INTEGER
```
public static final DataType<BigInteger> DECIMAL_INTEGER
```
  The zero-scale Types.DECIMAL type.
- TINYINTUNSIGNED
```
public static final DataType<UByte> TINYINTUNSIGNED
```
  The unsigned Types.TINYINT type.
- SMALLINTUNSIGNED
```
public static final DataType<UShort> SMALLINTUNSIGNED
```
  The unsigned Types.SMALLINT type.
- INTEGERUNSIGNED
```
public static final DataType<UInteger> INTEGERUNSIGNED
```
  The unsigned Types.INTEGER type.
- BIGINTUNSIGNED
```
public static final DataType<ULong> BIGINTUNSIGNED
```
  The unsigned Types.BIGINT type.
- DOUBLE
```
public static final DataType<Double> DOUBLE
```
  The Types.DOUBLE type.
- FLOAT
```
public static final DataType<Double> FLOAT
```
  The Types.FLOAT type.
- REAL
```
public static final DataType<Float> REAL
```
  The Types.REAL type.
- NUMERIC
```
public static final DataType<BigDecimal> NUMERIC
```
  The Types.NUMERIC type.
- DECIMAL
```
public static final DataType<BigDecimal> DECIMAL
```
  The Types.DECIMAL type.
- DATE
```
public static final DataType<Date> DATE
```
  The Types.DATE type.
- TIMESTAMP
```
public static final DataType<Timestamp> TIMESTAMP
```
  The Types.TIMESTAMP type.
- TIME
```
public static final DataType<Time> TIME
```
  The Types.TIME type.
- INTERVALYEARTOMONTH
```
public static final DataType<YearToMonth> INTERVALYEARTOMONTH
```
  The SQL standard INTERVAL YEAR TO MONTH data type.
- INTERVALDAYTOSECOND
```
public static final DataType<DayToSecond> INTERVALDAYTOSECOND
```
  The SQL standard INTERVAL DAY TO SECOND data type.
- LOCALDATE
```
public static final DataType<java.time.LocalDate> LOCALDATE
```
  The Types.DATE type.
- LOCALTIME
```
public static final DataType<java.time.LocalTime> LOCALTIME
```
  The Types.TIME type.
- LOCALDATETIME
```
public static final DataType<java.time.LocalDateTime> LOCALDATETIME
```
  The Types.TIMESTAMP type.
- OFFSETTIME
```
public static final DataType<java.time.OffsetTime> OFFSETTIME
```
  The Types.TIME_WITH_TIMEZONE type.
  The behaviour of this data type is influenced by the JDBC driver and the database that is used. Some databases support actual time zones (as in ZonedDateTime), other databases support only offsets (as in OffsetDateTime). Some databases retain the actual time zone information that is stored and reproduce it with every fetch (e.g. SQLDialect.ORACLE), others use this type as a synonym for a timestamp in UTC (e.g. SQLDialect.POSTGRES), producing possibly a value in the current time zone of the database or the client. Please refer to your database for more information about the behaviour of this data type.
- OFFSETDATETIME
```
public static final DataType<java.time.OffsetDateTime> OFFSETDATETIME
```
  The Types.TIMESTAMP_WITH_TIMEZONE type.
  The behaviour of this data type is influenced by the JDBC driver and the database that is used. Some databases support actual time zones (as in ZonedDateTime), other databases support only offsets (as in OffsetDateTime). Some databases retain the actual time zone information that is stored and reproduce it with every fetch (e.g. SQLDialect.ORACLE), others use this type as a synonym for a timestamp in UTC (e.g. SQLDialect.POSTGRES), producing possibly a value in the current time zone of the database or the client. Please refer to your database for more information about the behaviour of this data type.
- TIMEWITHTIMEZONE
```
public static final DataType<java.time.OffsetTime> TIMEWITHTIMEZONE
```
  The Types.TIME_WITH_TIMEZONE type.
  An alias for OFFSETTIME
- TIMESTAMPWITHTIMEZONE
```
public static final DataType<java.time.OffsetDateTime> TIMESTAMPWITHTIMEZONE
```
  The Types.TIMESTAMP_WITH_TIMEZONE type.
  An alias for OFFSETDATETIME
- BINARY
```
public static final DataType<byte[]> BINARY
```
  The Types.BINARY type.
- VARBINARY
```
public static final DataType<byte[]> VARBINARY
```
  The Types.VARBINARY type.
- LONGVARBINARY
```
public static final DataType<byte[]> LONGVARBINARY
```
  The Types.LONGVARBINARY type.
- BLOB
```
public static final DataType<byte[]> BLOB
```
  The Types.BLOB type.
- OTHER
```
public static final DataType<Object> OTHER
```
  The Types.OTHER type.
- RECORD
```
public static final DataType<Record> RECORD
```
  The Types.STRUCT type.
- RESULT
```
public static final DataType<Result<Record>> RESULT
```
  The ResultSet type.
  This is not a SQL or JDBC standard. This type emulates REF CURSOR types and similar constructs
- UUID
```
public static final DataType<UUID> UUID
```
  The UUID type.
  This is not a SQL or JDBC standard. This type handles UUID types where they are supported

Method Detail

VARCHAR

public static final DataType<String> VARCHAR(int length)

The Types.VARCHAR type.

CHAR

public static final DataType<String> CHAR(int length)

The Types.CHAR type.

LONGVARCHAR

public static final DataType<String> LONGVARCHAR(int length)

The Types.LONGVARCHAR type.

CLOB

public static final DataType<String> CLOB(int length)

The Types.CLOB type.

NVARCHAR

public static final DataType<String> NVARCHAR(int length)

The Types.NVARCHAR type.

NCHAR

public static final DataType<String> NCHAR(int length)

The Types.NCHAR type.

LONGNVARCHAR

public static final DataType<String> LONGNVARCHAR(int length)

The Types.LONGNVARCHAR type.

NCLOB

public static final DataType<String> NCLOB(int length)

The Types.NCLOB type.

NUMERIC

public static final DataType<BigDecimal> NUMERIC(int precision)

The Types.NUMERIC type.

NUMERIC

public static final DataType<BigDecimal> NUMERIC(int precision,
                                                 int scale)

The Types.NUMERIC type.

DECIMAL

public static final DataType<BigDecimal> DECIMAL(int precision)

The Types.DECIMAL type.

DECIMAL

public static final DataType<BigDecimal> DECIMAL(int precision,
                                                 int scale)

The Types.DECIMAL type.

BINARY

public static final DataType<byte[]> BINARY(int length)

The Types.BINARY type.

VARBINARY

public static final DataType<byte[]> VARBINARY(int length)

The Types.VARBINARY type.

LONGVARBINARY

public static final DataType<byte[]> LONGVARBINARY(int length)

The Types.LONGVARBINARY type.

BLOB

public static final DataType<byte[]> BLOB(int length)

The Types.BLOB type.

Class SQLDataType

Field Summary

Method Summary

Methods inherited from class java.lang.Object

Field Detail

VARCHAR

CHAR

LONGVARCHAR

CLOB

NVARCHAR

NCHAR

LONGNVARCHAR

NCLOB

BOOLEAN

BIT

TINYINT

SMALLINT

INTEGER

BIGINT

DECIMAL_INTEGER

TINYINTUNSIGNED

SMALLINTUNSIGNED

INTEGERUNSIGNED

BIGINTUNSIGNED

DOUBLE

FLOAT

REAL

NUMERIC

DECIMAL

DATE

TIMESTAMP

TIME

INTERVALYEARTOMONTH

INTERVALDAYTOSECOND

LOCALDATE

LOCALTIME

LOCALDATETIME

OFFSETTIME

OFFSETDATETIME

TIMEWITHTIMEZONE

TIMESTAMPWITHTIMEZONE

BINARY

VARBINARY

LONGVARBINARY

BLOB

OTHER

RECORD

RESULT

UUID

Method Detail

VARCHAR

CHAR

LONGVARCHAR

CLOB

NVARCHAR

NCHAR

LONGNVARCHAR

NCLOB

NUMERIC

NUMERIC

DECIMAL

DECIMAL

BINARY

VARBINARY

LONGVARBINARY

BLOB