org.jooq.util.mysql

Class MySQLDataType

java.lang.Object

org.jooq.util.mysql.MySQLDataType

public class MySQLDataType
extends java.lang.Object

Supported data types for the SQLDialect.MYSQL dialect

Author:

Lukas Eder

See Also:

http://dev.mysql.com/doc/refman/5.5/en/data-types.html, http://dev.mysql.com/doc/refman/5.5/en/cast-functions.html#function_cast

Field Summary

Fields

Modifier and Type	Field and Description
protected static DataType<java.math.BigInteger>	__BIGINTEGER
protected static DataType<java.lang.String>	__LONGNVARCHAR
protected static DataType<byte[]>	__LONGVARBINARY
protected static DataType<java.lang.String>	__LONGVARCHAR
protected static DataType<java.lang.String>	__NCHAR
protected static DataType<java.lang.String>	__NCLOB
protected static DataType<java.math.BigDecimal>	__NUMERIC
protected static DataType<java.lang.String>	__NVARCHAR
protected static DataType<java.util.UUID>	__UUID
static DataType<java.lang.Long>	BIGINT
static DataType<ULong>	BIGINTUNSIGNED
static DataType<byte[]>	BINARY
static DataType<java.lang.Boolean>	BIT
static DataType<byte[]>	BLOB
static DataType<java.lang.Boolean>	BOOL
static DataType<java.lang.Boolean>	BOOLEAN
static DataType<java.lang.String>	CHAR
static DataType<java.sql.Date>	DATE
static DataType<java.sql.Timestamp>	DATETIME
static DataType<java.math.BigDecimal>	DEC
static DataType<java.math.BigDecimal>	DECIMAL
static DataType<java.lang.Double>	DOUBLE
static DataType<java.lang.String>	ENUM
static DataType<java.lang.Double>	FLOAT
static DataType<java.lang.Integer>	INT
static DataType<java.lang.Integer>	INTEGER
static DataType<UInteger>	INTEGERUNSIGNED
static DataType<UInteger>	INTUNSIGNED
static DataType<byte[]>	LONGBLOB
static DataType<java.lang.String>	LONGTEXT
static DataType<byte[]>	MEDIUMBLOB
static DataType<java.lang.Integer>	MEDIUMINT
static DataType<UInteger>	MEDIUMINTUNSIGNED
static DataType<java.lang.String>	MEDIUMTEXT
static DataType<java.lang.Float>	REAL
static DataType<java.lang.String>	SET
static DataType<java.lang.Short>	SMALLINT
static DataType<UShort>	SMALLINTUNSIGNED
static DataType<java.lang.String>	TEXT
static DataType<java.sql.Time>	TIME
static DataType<java.sql.Timestamp>	TIMESTAMP
static DataType<byte[]>	TINYBLOB
static DataType<java.lang.Byte>	TINYINT
static DataType<UByte>	TINYINTUNSIGNED
static DataType<java.lang.String>	TINYTEXT
static DataType<byte[]>	VARBINARY
static DataType<java.lang.String>	VARCHAR
static DataType<java.sql.Date>	YEAR

Constructor Summary

Constructors

Constructor and Description
MySQLDataType()

Method Summary

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Field Detail

TINYINT

public static final DataType<java.lang.Byte> TINYINT

TINYINTUNSIGNED

public static final DataType<UByte> TINYINTUNSIGNED

SMALLINT

public static final DataType<java.lang.Short> SMALLINT

SMALLINTUNSIGNED

public static final DataType<UShort> SMALLINTUNSIGNED

INT

public static final DataType<java.lang.Integer> INT

INTUNSIGNED

public static final DataType<UInteger> INTUNSIGNED

MEDIUMINT

public static final DataType<java.lang.Integer> MEDIUMINT

MEDIUMINTUNSIGNED

public static final DataType<UInteger> MEDIUMINTUNSIGNED

INTEGER

public static final DataType<java.lang.Integer> INTEGER

INTEGERUNSIGNED

public static final DataType<UInteger> INTEGERUNSIGNED

BIGINT

public static final DataType<java.lang.Long> BIGINT

BIGINTUNSIGNED

public static final DataType<ULong> BIGINTUNSIGNED

DOUBLE

public static final DataType<java.lang.Double> DOUBLE

FLOAT

public static final DataType<java.lang.Double> FLOAT

REAL

public static final DataType<java.lang.Float> REAL

BOOLEAN

public static final DataType<java.lang.Boolean> BOOLEAN

BOOL

public static final DataType<java.lang.Boolean> BOOL

BIT

public static final DataType<java.lang.Boolean> BIT

DECIMAL

public static final DataType<java.math.BigDecimal> DECIMAL

DEC

public static final DataType<java.math.BigDecimal> DEC

VARCHAR

public static final DataType<java.lang.String> VARCHAR

CHAR

public static final DataType<java.lang.String> CHAR

TEXT

public static final DataType<java.lang.String> TEXT

BLOB

public static final DataType<byte[]> BLOB

BINARY

public static final DataType<byte[]> BINARY

VARBINARY

public static final DataType<byte[]> VARBINARY

DATE

public static final DataType<java.sql.Date> DATE

TIME

public static final DataType<java.sql.Time> TIME

TIMESTAMP

public static final DataType<java.sql.Timestamp> TIMESTAMP

DATETIME

public static final DataType<java.sql.Timestamp> DATETIME

__NCHAR

protected static final DataType<java.lang.String> __NCHAR

__NCLOB

protected static final DataType<java.lang.String> __NCLOB

__LONGNVARCHAR

protected static final DataType<java.lang.String> __LONGNVARCHAR

__NUMERIC

protected static final DataType<java.math.BigDecimal> __NUMERIC

__NVARCHAR

protected static final DataType<java.lang.String> __NVARCHAR

__LONGVARCHAR

protected static final DataType<java.lang.String> __LONGVARCHAR

__LONGVARBINARY

protected static final DataType<byte[]> __LONGVARBINARY

__BIGINTEGER

protected static final DataType<java.math.BigInteger> __BIGINTEGER

__UUID

protected static final DataType<java.util.UUID> __UUID

TINYTEXT

public static final DataType<java.lang.String> TINYTEXT

MEDIUMTEXT

public static final DataType<java.lang.String> MEDIUMTEXT

LONGTEXT

public static final DataType<java.lang.String> LONGTEXT

ENUM

public static final DataType<java.lang.String> ENUM

SET

public static final DataType<java.lang.String> SET

TINYBLOB

public static final DataType<byte[]> TINYBLOB

MEDIUMBLOB

public static final DataType<byte[]> MEDIUMBLOB

LONGBLOB

public static final DataType<byte[]> LONGBLOB

YEAR

public static final DataType<java.sql.Date> YEAR

Constructor Detail

MySQLDataType

public MySQLDataType()