SQLDataType (jOOQ 3.8.9 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
- 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

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