DataType (XDEV Application Framework 6.0.0 API)

java.lang.Object
- java.lang.Enum<DataType>
- - xdev.db.DataType

All Implemented Interfaces:

Serializable, Comparable<DataType>
```
public enum DataType
extends Enum<DataType>
```
The class that defines the constants that are used to identify SQL types.

Author:

XDEV Software

Enum Constant Summary

Enum Constants
Enum Constant and Description
`BIGINT` 64-bit signed integer value between -9223372036854775808 and 9223372036854775807.
`BINARY` Fixed length binary value.
`BLOB` Big variable length binary value.
`BOOLEAN` 1-bit value, which is either 1 or 0, true of false.
`CHAR` Fixed length character string.
`CLOB` Big variable length character string.
`DATE` Day, month and year.
`DECIMAL` Lax fixed-precision decimal number which takes precision and scale parameters.
`DOUBLE` Double precision floating point number that supports 15 digits of mantissa.
`FLOAT` Double precision floating point number that supports 15 digits of mantissa, basically the same type as `DOUBLE`, which should be preferred instead of FLOAT.
`INTEGER` 32-bit signed integer value between -2147483648 and 2147483647.
`LONGVARBINARY` Big variable length binary value with length param.
`LONGVARCHAR` Big variable length character string with length param.
`NUMERIC` Severe fixed-precision decimal number which takes precision and scale parameters.
`OBJECT` Object and Others
`REAL` Single precision floating point number that supports 7 digits of mantissa.
`SMALLINT` 16-bit signed integer value between -32768 and 32767.
`TIME` Hours, minutes and seconds.
`TIMESTAMP` `DATE` + `TIME` + Nanoseconds.
`TINYINT` 8-bit integer value between 0 and 255, signed or unsigned.
`VARBINARY` Small variable length binary value with length param.
`VARCHAR` Small variable length character string with length param.

Method Summary

All Methods Static Methods Instance Methods Concrete Methods
Modifier and Type	Method and Description
`static DataType`	`get(int sqlType)` Returns the matching `DataType` for the `sqlType`.
`static List<DataType>`	`getBlobTypes()` Returns a `List` containing `DataType`s which are `Binary` typed.
`static List<DataType>`	`getDateTypes()` Returns a `List` containing `DataType`s which are `Date` typed.
`static List<DataType>`	`getDecimalTypes()` Returns a `List` containing `DataType`s which are `Decimal` typed.
`static List<DataType>`	`getIntTypes()` Returns a `List` containing `DataType`s which are `Integer` typed.
`Class<?>`	`getJavaClass()` Gets the java class for this `DataType`.
`static List<DataType>`	`getNumericTypes()` Returns a `List` containing `DataType`s which are `Number` typed.
`SQL.DATATYPE`	`getSqlType()` Gets the sql type for this `DataType`.
`static List<DataType>`	`getStringTypes()` Returns a `List` containing `DataType`s which are `String` typed.
`boolean`	`hasLength()` Verify if this `DataType` has a length.
`boolean`	`hasScale()` Verify if this `DataType` has a scale.
`boolean`	`isBlob()` Check if `this` is an blob `DataType`.
`boolean`	`isDate()` Check if `this` is an date `DataType`.
`boolean`	`isDecimal()` Check if `this` is an decimal `DataType`.
`boolean`	`isInt()` Check if `this` is an integer `DataType`.
`boolean`	`isNumeric()` Check if `this` is numeric `DataType`.
`boolean`	`isString()` Check if `this` is an string `DataType`.
`static DataType`	`valueOf(String name)` Returns the enum constant of this type with the specified name.
`static DataType[]`	`values()` Returns an array containing the constants of this enum type, in the order they are declared.

Methods inherited from class java.lang.Enum
clone, compareTo, equals, finalize, getDeclaringClass, hashCode, name, ordinal, toString, valueOf

Methods inherited from class java.lang.Object
getClass, notify, notifyAll, wait, wait, wait

- Enum Constant Detail
  - TINYINT
```
public static final DataType TINYINT
```
    8-bit integer value between 0 and 255, signed or unsigned.
  - SMALLINT
```
public static final DataType SMALLINT
```
    16-bit signed integer value between -32768 and 32767.
  - INTEGER
```
public static final DataType INTEGER
```
    32-bit signed integer value between -2147483648 and 2147483647.
  - BIGINT
```
public static final DataType BIGINT
```
    64-bit signed integer value between -9223372036854775808 and 9223372036854775807.
  - REAL
```
public static final DataType REAL
```
    Single precision floating point number that supports 7 digits of mantissa.
  - DOUBLE
```
public static final DataType DOUBLE
```
    Double precision floating point number that supports 15 digits of mantissa.
  - FLOAT
```
public static final DataType FLOAT
```
    Double precision floating point number that supports 15 digits of mantissa, basically the same type as DOUBLE, which should be preferred instead of FLOAT.
  - NUMERIC
```
public static final DataType NUMERIC
```
    Severe fixed-precision decimal number which takes precision and scale parameters.
  - DECIMAL
```
public static final DataType DECIMAL
```
    Lax fixed-precision decimal number which takes precision and scale parameters.
  - BOOLEAN
```
public static final DataType BOOLEAN
```
    1-bit value, which is either 1 or 0, true of false.
  - CHAR
```
public static final DataType CHAR
```
    Fixed length character string.
  - VARCHAR
```
public static final DataType VARCHAR
```
    Small variable length character string with length param.
  - LONGVARCHAR
```
public static final DataType LONGVARCHAR
```
    Big variable length character string with length param.
  - CLOB
```
public static final DataType CLOB
```
    Big variable length character string.
  - BINARY
```
public static final DataType BINARY
```
    Fixed length binary value.
  - VARBINARY
```
public static final DataType VARBINARY
```
    Small variable length binary value with length param.
  - LONGVARBINARY
```
public static final DataType LONGVARBINARY
```
    Big variable length binary value with length param.
  - BLOB
```
public static final DataType BLOB
```
    Big variable length binary value.
  - DATE
```
public static final DataType DATE
```
    Day, month and year.
  - TIME
```
public static final DataType TIME
```
    Hours, minutes and seconds.
  - OBJECT
```
public static final DataType OBJECT
```
    Object and Others
  - TIMESTAMP
```
public static final DataType TIMESTAMP
```
    DATE + TIME + Nanoseconds.
- Method Detail
  - values
```
public static DataType[] values()
```
    Returns an array containing the constants of this enum type, in the order they are declared. This method may be used to iterate over the constants as follows:
```
for (DataType c : DataType.values())
    System.out.println(c);
```
    Returns:
    
    an array containing the constants of this enum type, in the order they are declared
  - valueOf
```
public static DataType valueOf(String name)
```
    Returns the enum constant of this type with the specified name. The string must match exactly an identifier used to declare an enum constant in this type. (Extraneous whitespace characters are not permitted.)
    
    Parameters:
    
    name - the name of the enum constant to be returned.
    
    Returns:
    
    the enum constant with the specified name
    
    Throws:
    
    IllegalArgumentException - if this enum type has no constant with the specified name
    
    NullPointerException - if the argument is null
  - getJavaClass
```
public Class<?> getJavaClass()
```
    Gets the java class for this DataType.
    
    Returns:
    
    the java class
  - getSqlType
```
public SQL.DATATYPE getSqlType()
```
    Gets the sql type for this DataType.
    
    Returns:
    
    the SQL.DATATYPE
  - isInt
```
public boolean isInt()
```
    Check if this is an integer DataType.
    Integer DataType are:
    Returns:
    
    true if this is an integer DataType, otherwise false
  - isDecimal
```
public boolean isDecimal()
```
    Check if this is an decimal DataType.
    Decimal DataType are:
    Returns:
    
    true if this is an decimal DataType, otherwise false
  - isNumeric
```
public boolean isNumeric()
```
    Check if this is numeric DataType.
    Numeric DataType are:
    Returns:
    
    true if this is a numeric value DataType, otherwise false
    
    Since:
    
    4.0
  - isString
```
public boolean isString()
```
    Check if this is an string DataType.
    String DataType are:
    Returns:
    
    true if this is an string DataType, otherwise false
  - isBlob
```
public boolean isBlob()
```
    Check if this is an blob DataType.
    Blob DataType are:
    Returns:
    
    true if this is an blob DataType, otherwise false
  - isDate
```
public boolean isDate()
```
    Check if this is an date DataType.
    Date DataType are:
    Returns:
    
    true if this is an date DataType, otherwise false
  - hasLength
```
public boolean hasLength()
```
    Verify if this DataType has a length.
    
    Returns:
    
    true if the DataType has a length, otherwise false
    
    See Also:
    
    hasScale()
  - hasScale
```
public boolean hasScale()
```
    Verify if this DataType has a scale.
    
    Returns:
    
    true if the DataType has a scale, otherwise false
    
    See Also:
    
    hasLength()
  - getStringTypes
```
public static List<DataType> getStringTypes()
```
    Returns a List containing DataTypes which are String typed.
    
    Returns:
    
    string typed DataTypes.
    
    Since:
    
    4.0
  - getNumericTypes
```
public static List<DataType> getNumericTypes()
```
    Returns a List containing DataTypes which are Number typed.
    
    Returns:
    
    number typed DataTypes.
    
    Since:
    
    4.0
  - getBlobTypes
```
public static List<DataType> getBlobTypes()
```
    Returns a List containing DataTypes which are Binary typed.
    
    Returns:
    
    binary typed DataTypes.
    
    Since:
    
    4.0
  - getDateTypes
```
public static List<DataType> getDateTypes()
```
    Returns a List containing DataTypes which are Date typed.
    
    Returns:
    
    date typed DataTypes.
    
    Since:
    
    4.0
  - getDecimalTypes
```
public static List<DataType> getDecimalTypes()
```
    Returns a List containing DataTypes which are Decimal typed.
    
    Returns:
    
    decimal typed DataTypes.
    
    Since:
    
    4.0
  - getIntTypes
```
public static List<DataType> getIntTypes()
```
    Returns a List containing DataTypes which are Integer typed.
    
    Returns:
    
    integer typed DataTypes.
    
    Since:
    
    4.0
  - get
```
public static DataType get(int sqlType)
```
    Returns the matching DataType for the sqlType.
    
    Parameters:
    
    sqlType - the sql type
    
    Returns:
    
    the matching DataType

Enum DataType

Enum Constant Summary

Method Summary

Methods inherited from class java.lang.Enum

Methods inherited from class java.lang.Object

Enum Constant Detail

TINYINT

SMALLINT

INTEGER

BIGINT

REAL

DOUBLE

FLOAT

NUMERIC

DECIMAL

BOOLEAN

CHAR

VARCHAR

LONGVARCHAR

CLOB

BINARY

VARBINARY

LONGVARBINARY

BLOB

DATE

TIME

OBJECT

TIMESTAMP

Method Detail

values

valueOf

getJavaClass

getSqlType

isInt

isDecimal

isNumeric

isString

isBlob

isDate

hasLength

hasScale

getStringTypes

getNumericTypes

getBlobTypes

getDateTypes

getDecimalTypes

getIntTypes

get