org.jooq.util.sqlserver

Class SQLServerDataType

java.lang.Object

org.jooq.util.sqlserver.SQLServerDataType

public class SQLServerDataType
extends Object

Supported data types for the SQLDialect.SQLSERVER dialect family.

This includes the

• SQLDialect.SQLSERVER2008 dialect
• SQLDialect.SQLSERVER2012 dialect

Author:

Lukas Eder

See Also:

http://msdn.microsoft.com/en-us/library/aa258271%28v=sql.80%29.aspx

Field Summary

Fields

Modifier and Type	Field and Description
protected static DataType<BigInteger>	__BIGINTEGER
protected static DataType<ULong>	__BIGINTUNSIGNED
protected static DataType<byte[]>	__BLOB
protected static DataType<Boolean>	__BOOLEAN
protected static DataType<Byte>	__BYTE
protected static DataType<Double>	__DOUBLE
protected static DataType<UInteger>	__INTEGERUNSIGNED
protected static DataType<String>	__LONGNVARCHAR
protected static DataType<byte[]>	__LONGVARBINARY
protected static DataType<String>	__LONGVARCHAR
protected static DataType<String>	__NCLOB
protected static DataType<UShort>	__SMALLINTUNSIGNED
static DataType<Long>	BIGINT
static DataType<byte[]>	BINARY
static DataType<Boolean>	BIT
static DataType<String>	CHAR
static DataType<Date>	DATE
static DataType<Timestamp>	DATETIME
static DataType<Timestamp>	DATETIME2
static DataType<Timestamp>	DATETIMEOFFSET
static DataType<BigDecimal>	DECIMAL
static DataType<Double>	FLOAT
static DataType<byte[]>	IMAGE
static DataType<Integer>	INT
static DataType<BigDecimal>	MONEY
static DataType<String>	NCHAR
static DataType<String>	NTEXT
static DataType<BigDecimal>	NUMERIC
static DataType<String>	NVARCHAR
static DataType<Float>	REAL
static DataType<Long>	ROWVERSION
static DataType<Timestamp>	SMALLDATETIME
static DataType<Short>	SMALLINT
static DataType<BigDecimal>	SMALLMONEY
static DataType<String>	TEXT
static DataType<Time>	TIME
static DataType<Long>	TIMESTAMP
static DataType<UByte>	TINYINT
static DataType<UUID>	UNIQUEIDENTIFIER
static DataType<byte[]>	VARBINARY
static DataType<String>	VARCHAR

Constructor Summary

Constructors

Constructor and Description
SQLServerDataType()

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<UByte> TINYINT

SMALLINT

public static final DataType<Short> SMALLINT

INT

public static final DataType<Integer> INT

BIGINT

public static final DataType<Long> BIGINT

FLOAT

public static final DataType<Double> FLOAT

REAL

public static final DataType<Float> REAL

NUMERIC

public static final DataType<BigDecimal> NUMERIC

DECIMAL

public static final DataType<BigDecimal> DECIMAL

BIT

public static final DataType<Boolean> BIT

DATE

public static final DataType<Date> DATE

DATETIME

public static final DataType<Timestamp> DATETIME

TIME

public static final DataType<Time> TIME

VARCHAR

public static final DataType<String> VARCHAR

CHAR

public static final DataType<String> CHAR

TEXT

public static final DataType<String> TEXT

NVARCHAR

public static final DataType<String> NVARCHAR

NCHAR

public static final DataType<String> NCHAR

NTEXT

public static final DataType<String> NTEXT

VARBINARY

public static final DataType<byte[]> VARBINARY

BINARY

public static final DataType<byte[]> BINARY

__BLOB

protected static final DataType<byte[]> __BLOB

__BOOLEAN

protected static final DataType<Boolean> __BOOLEAN

__DOUBLE

protected static final DataType<Double> __DOUBLE

__LONGVARBINARY

protected static final DataType<byte[]> __LONGVARBINARY

__LONGVARCHAR

protected static final DataType<String> __LONGVARCHAR

__NCLOB

protected static final DataType<String> __NCLOB

__LONGNVARCHAR

protected static final DataType<String> __LONGNVARCHAR

__BYTE

protected static final DataType<Byte> __BYTE

__BIGINTEGER

protected static final DataType<BigInteger> __BIGINTEGER

__SMALLINTUNSIGNED

protected static final DataType<UShort> __SMALLINTUNSIGNED

__INTEGERUNSIGNED

protected static final DataType<UInteger> __INTEGERUNSIGNED

__BIGINTUNSIGNED

protected static final DataType<ULong> __BIGINTUNSIGNED

SMALLDATETIME

public static final DataType<Timestamp> SMALLDATETIME

DATETIME2

public static final DataType<Timestamp> DATETIME2

DATETIMEOFFSET

public static final DataType<Timestamp> DATETIMEOFFSET

MONEY

public static final DataType<BigDecimal> MONEY

SMALLMONEY

public static final DataType<BigDecimal> SMALLMONEY

IMAGE

public static final DataType<byte[]> IMAGE

UNIQUEIDENTIFIER

public static final DataType<UUID> UNIQUEIDENTIFIER

ROWVERSION

public static final DataType<Long> ROWVERSION

TIMESTAMP

public static final DataType<Long> TIMESTAMP

Constructor Detail

SQLServerDataType

public SQLServerDataType()