java.lang.Object
- java.lang.Enum<DataType>
- - com.healthmarketscience.jackcess.DataType

All Implemented Interfaces:

Serializable, Comparable<DataType>
```
public enum DataType
extends Enum<DataType>
```
Supported access data types.

Author:

Tim McCune

Usage:

General: This class is general use.

Enum Constant Summary

Enum Constants
Enum Constant	Description
`BIG_BINARY`	A fixed length binary column longer than the 255 byte `BINARY`, which the engine calls "BigBinary".
`BIG_INT`	Corresponds to a java `Long`.
`BINARY`	Corresponds to a java `byte[]` of max length 255 bytes.
`BOOLEAN`	Corresponds to a java `Boolean`.
`BYTE`	Corresponds to a java `Byte`.
`COMPLEX_TYPE`	Complex type corresponds to a special `LONG` autonumber field which is the key for a secondary table which holds the "real" data.
`DOUBLE`	Corresponds to a java `Double`.
`EXT_DATE_TIME`	Corresponds to a java `LocalDateTime` (with 7 digits of nanosecond precision).
`FLOAT`	Corresponds to a java `Float`.
`GUID`	Corresponds to a java `String` with the pattern `"{xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx}"`, also known as a "Replication ID" in Access.
`INT`	Corresponds to a java `Short`.
`LONG`	Corresponds to a java `Integer`.
`MEMO`	Corresponds to a java `String` of max length 8388607 chars.
`MONEY`	Corresponds to a java `BigDecimal` with at most 4 decimal places.
`NUMERIC`	Corresponds to a java `BigDecimal`.
`OLE`	Corresponds to a java `byte[]` of max length 16777215 bytes.
`SHORT_DATE_TIME`	Corresponds to a java `Date` or `LocalDateTime`.
`TEXT`	Corresponds to a java `String` of max length 255 chars.
`UNSUPPORTED_FIXEDLEN`	Dummy type for a fixed length type which is not currently supported.
`UNSUPPORTED_VARLEN`	Placeholder type for a variable length type which is not currently supported.

Method Summary

All Methods Static Methods Instance Methods Concrete Methods
Modifier and Type	Method	Description
`static DataType`	`fromByte(byte b)`
`static DataType`	`fromSQLType(int sqlType)`
`static DataType`	`fromSQLType(int sqlType, int lengthInUnits)`
`static DataType`	`fromSQLType(int sqlType, int lengthInUnits, Database.FileFormat fileFormat)`
`int`	`fromUnitSize(int unitSize)`
`int`	`fromUnitSize(int unitSize, JetFormat format)`
`int`	`getDefaultPrecision()`
`int`	`getDefaultScale()`
`int`	`getDefaultSize()`
`int`	`getFixedSize()`
`int`	`getFixedSize(Short colLength)`
`boolean`	`getHasScalePrecision()`
`int`	`getMaxPrecision()`
`int`	`getMaxScale()`
`int`	`getMaxSize()`
`int`	`getMinPrecision()`
`int`	`getMinScale()`
`int`	`getMinSize()`
`int`	`getSQLType()`
`int`	`getUnitSize()`
`int`	`getUnitSize(JetFormat format)`
`byte`	`getValue()`
`boolean`	`isLongValue()`
`boolean`	`isMultipleAutoNumberAllowed()`
`boolean`	`isTextual()`
`boolean`	`isTrueVariableLength()`
`boolean`	`isUnsupported()`
`boolean`	`isValidPrecision(int precision)`
`boolean`	`isValidScale(int scale)`
`boolean`	`isValidSize(int size)`
`boolean`	`isVariableLength()`
`boolean`	`mayBeAutoNumber()`
`int`	`toUnitSize(int size)`
`int`	`toUnitSize(int size, JetFormat format)`
`int`	`toValidPrecision(int precision)`
`int`	`toValidScale(int scale)`
`int`	`toValidSize(int size)`
`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
compareTo, equals, getDeclaringClass, hashCode, name, ordinal, toString, valueOf

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

- Enum Constant Detail
  - BOOLEAN
```
public static final DataType BOOLEAN
```
    Corresponds to a java Boolean. Accepts Boolean or null (which is considered false). Equivalent to SQL Types.BOOLEAN.
  - BYTE
```
public static final DataType BYTE
```
    Corresponds to a java Byte. Accepts any Number (using Number.byteValue()), Boolean as 1 or 0, any Object converted to a String and parsed as Double, or null. Equivalent to SQL Types.TINYINT, Types.BIT.
  - INT
```
public static final DataType INT
```
    Corresponds to a java Short. Accepts any Number (using Number.shortValue()), Boolean as 1 or 0, any Object converted to a String and parsed as Double, or null. Equivalent to SQL Types.SMALLINT.
  - LONG
```
public static final DataType LONG
```
    Corresponds to a java Integer. Accepts any Number (using Number.intValue()), Boolean as 1 or 0, any Object converted to a String and parsed as Double, or null. Equivalent to SQL Types.INTEGER, Types.BIGINT.
  - MONEY
```
public static final DataType MONEY
```
    Corresponds to a java BigDecimal with at most 4 decimal places. Accepts any Number (using Number.doubleValue()), a BigInteger, a BigDecimal (with at most 4 decimal places), Boolean as 1 or 0, any Object converted to a String and parsed as BigDecimal, or null. Equivalent to SQL Types.DECIMAL.
  - FLOAT
```
public static final DataType FLOAT
```
    Corresponds to a java Float. Accepts any Number (using Number.floatValue()), Boolean as 1 or 0, any Object converted to a String and parsed as Double, or null. Equivalent to SQL Types.FLOAT.
  - DOUBLE
```
public static final DataType DOUBLE
```
    Corresponds to a java Double. Accepts any Number (using Number.doubleValue()), Boolean as 1 or 0, any Object converted to a String and parsed as Double, or null. Equivalent to SQL Types.DOUBLE, Types.REAL.
  - SHORT_DATE_TIME
```
public static final DataType SHORT_DATE_TIME
```
    Corresponds to a java Date or LocalDateTime. Accepts a Date, LocalDateTime (or related types), any Number (using Number.longValue()), or null. Equivalent to SQL Types.TIMESTAMP, Types.DATE, Types.TIME.
  - BINARY
```
public static final DataType BINARY
```
    Corresponds to a java byte[] of max length 255 bytes. Accepts a byte[], or null. Equivalent to SQL Types.BINARY, Types.VARBINARY.
  - TEXT
```
public static final DataType TEXT
```
    Corresponds to a java String of max length 255 chars. Accepts any CharSequence, any Object converted to a String , or null. Equivalent to SQL Types.VARCHAR, Types.CHAR.
  - OLE
```
public static final DataType OLE
```
    Corresponds to a java byte[] of max length 16777215 bytes. Accepts a byte[], or null. Equivalent to SQL Types.LONGVARBINARY, Types.BLOB.
  - MEMO
```
public static final DataType MEMO
```
    Corresponds to a java String of max length 8388607 chars. Accepts any CharSequence, any Object converted to a String , or null. Equivalent to SQL Types.LONGVARCHAR, Types.CLOB.
  - GUID
```
public static final DataType GUID
```
    Corresponds to a java String with the pattern "{xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx}", also known as a "Replication ID" in Access. Accepts any Object converted to a String matching this pattern (surrounding "{}" are optional, so UUIDs are supported), or null.
  - NUMERIC
```
public static final DataType NUMERIC
```
    Corresponds to a java BigDecimal. Accepts any Number (using Number.doubleValue()), a BigInteger, a BigDecimal, Boolean as 1 or 0, any Object converted to a String and parsed as BigDecimal, or null. Equivalent to SQL Types.NUMERIC.
  - BIG_BINARY
```
public static final DataType BIG_BINARY
```
    A fixed length binary column longer than the 255 byte BINARY, which the engine calls "BigBinary". Only the Data column of MSysAccessObjects uses it, which holds the forms, reports and VBA of the database. Jet4 only, since Jet3 used BINARY for that column and the ACE engine dropped the table. Handled like a fixed length BINARY/OLE.
  - COMPLEX_TYPE
```
public static final DataType COMPLEX_TYPE
```
    Complex type corresponds to a special LONG autonumber field which is the key for a secondary table which holds the "real" data.
  - BIG_INT
```
public static final DataType BIG_INT
```
    Corresponds to a java Long. Accepts any Number (using Number.longValue()), Boolean as 1 or 0, any Object converted to a String and parsed as Double, or null. Equivalent to SQL Types.BIGINT.
  - EXT_DATE_TIME
```
public static final DataType EXT_DATE_TIME
```
    Corresponds to a java LocalDateTime (with 7 digits of nanosecond precision). Accepts a Date, LocalDateTime (or related types), any Number (using Number.longValue()), or null. Equivalent to SQL Types.TIMESTAMP, Types.DATE, Types.TIME.
  - UNSUPPORTED_FIXEDLEN
```
public static final DataType UNSUPPORTED_FIXEDLEN
```
    Dummy type for a fixed length type which is not currently supported. Handled like a fixed length BINARY.
  - UNSUPPORTED_VARLEN
```
public static final DataType UNSUPPORTED_VARLEN
```
    Placeholder type for a variable length type which is not currently supported. Handled like BINARY.
- 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
  - getValue
```
public byte getValue()
```
  - isVariableLength
```
public boolean isVariableLength()
```
  - isTrueVariableLength
```
public boolean isTrueVariableLength()
```
  - isLongValue
```
public boolean isLongValue()
```
  - getHasScalePrecision
```
public boolean getHasScalePrecision()
```
  - getFixedSize
```
public int getFixedSize()
```
  - getFixedSize
```
public int getFixedSize(Short colLength)
```
  - getMinSize
```
public int getMinSize()
```
  - getDefaultSize
```
public int getDefaultSize()
```
  - getMaxSize
```
public int getMaxSize()
```
  - getSQLType
```
public int getSQLType()
               throws IOException
```
    Throws:
    
    IOException
  - getMinScale
```
public int getMinScale()
```
  - getDefaultScale
```
public int getDefaultScale()
```
  - getMaxScale
```
public int getMaxScale()
```
  - getMinPrecision
```
public int getMinPrecision()
```
  - getDefaultPrecision
```
public int getDefaultPrecision()
```
  - getMaxPrecision
```
public int getMaxPrecision()
```
  - getUnitSize
```
public int getUnitSize()
```
  - getUnitSize
```
public int getUnitSize(JetFormat format)
```
  - toUnitSize
```
public int toUnitSize(int size)
```
  - toUnitSize
```
public int toUnitSize(int size,
                      JetFormat format)
```
  - fromUnitSize
```
public int fromUnitSize(int unitSize)
```
  - fromUnitSize
```
public int fromUnitSize(int unitSize,
                        JetFormat format)
```
  - isValidSize
```
public boolean isValidSize(int size)
```
  - isValidScale
```
public boolean isValidScale(int scale)
```
  - isValidPrecision
```
public boolean isValidPrecision(int precision)
```
  - toValidSize
```
public int toValidSize(int size)
```
  - toValidScale
```
public int toValidScale(int scale)
```
  - toValidPrecision
```
public int toValidPrecision(int precision)
```
  - isTextual
```
public boolean isTextual()
```
  - mayBeAutoNumber
```
public boolean mayBeAutoNumber()
```
  - isMultipleAutoNumberAllowed
```
public boolean isMultipleAutoNumberAllowed()
```
  - isUnsupported
```
public boolean isUnsupported()
```
  - fromByte
```
public static DataType fromByte(byte b)
                         throws IOException
```
    Throws:
    
    IOException
  - fromSQLType
```
public static DataType fromSQLType(int sqlType)
                            throws IOException
```
    Throws:
    
    IOException
  - fromSQLType
```
public static DataType fromSQLType(int sqlType,
                                   int lengthInUnits)
                            throws IOException
```
    Throws:
    
    IOException
  - fromSQLType
```
public static DataType fromSQLType(int sqlType,
                                   int lengthInUnits,
                                   Database.FileFormat fileFormat)
                            throws IOException
```
    Throws:
    
    IOException

Enum DataType

Enum Constant Summary

Method Summary

Methods inherited from class java.lang.Enum

Methods inherited from class java.lang.Object

Enum Constant Detail

BOOLEAN

BYTE

INT

LONG

MONEY

FLOAT

DOUBLE

SHORT_DATE_TIME

BINARY

TEXT

OLE

MEMO

GUID

NUMERIC

BIG_BINARY

COMPLEX_TYPE

BIG_INT

EXT_DATE_TIME

UNSUPPORTED_FIXEDLEN

UNSUPPORTED_VARLEN

Method Detail

values

valueOf

getValue

isVariableLength

isTrueVariableLength

isLongValue

getHasScalePrecision

getFixedSize

getFixedSize

getMinSize

getDefaultSize

getMaxSize

getSQLType

getMinScale

getDefaultScale

getMaxScale

getMinPrecision

getDefaultPrecision

getMaxPrecision

getUnitSize

getUnitSize

toUnitSize

toUnitSize

fromUnitSize

fromUnitSize

isValidSize

isValidScale

isValidPrecision

toValidSize

toValidScale

toValidPrecision

isTextual

mayBeAutoNumber

isMultipleAutoNumberAllowed

isUnsupported

fromByte

fromSQLType

fromSQLType

fromSQLType