org.jooq.impl

Class SQLDataType

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<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<Object>	OTHER The Types.OTHER type
static DataType<Float>	REAL The Types.REAL type
static DataType<Result<Record>>	RESULT The ResultSet type This is not a SQL or JDBC standard.
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<Byte>	TINYINT The Types.TINYINT type
static DataType<UByte>	TINYINTUNSIGNED The unsigned Types.TINYINT type
static DataType<UUID>	UUID The UUID type This is not a SQL or JDBC standard.
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

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

RESULT

public static final DataType<Result<Record>> RESULT

The ResultSet type

This is not a SQL or JDBC standard. This type simulates 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