DataType

Overview

The DataType enumeration designates a Schema filed's data type. Values of this type are used by the Data Abstract to store information about data types while processing data requests.

While some of the possible DataType map to the same Java data type they still can be processed differently by the database engine (f.e. String and WideMemo) they still can be processed differently by the undelying database engine and can map to different data types on platforms other than Java (like .Net, iOS, Win32 etc).

Location

Value Description
AutoInc Integer (32-bit) value that is auto-incremented by the database server. Table fields of this type cannot be updated.
Blob Binary Large OBject. Values of this type are serialized as an array of bytes.
Boolean Boolean value
Byte Integer (8-bit) value.
Cardinal Integer (32-bit) value.
Currency Currency value represented by java.math.BigDecimal type.
Cursor Reserved. Not supported yet.
DateTime DateTime value. Represented by java.util.Date.
Decimal Represented by java.math.BigDecimal type.
FixedChar UTF8-encoded String value
FixedWideChar Unicode-encoded String value
Float Double value.
Guid UUID value
Integer Integer (32-bit) value
LargeAutoInc Long (64-bit) value that is auto-incremented by the database server. Table fields of this type cannot be updated.
LargeInt Long (64-bit) value
LargeUInt Unsigned Long (64-bit) value

Currently values of this type aren't fully supported by the Data Abstract for Java as they are serialized and deserialized as signed long type, thus limiting the possible value range
Memo UTF8-encoded String value. Values of this type are used to store very long strings
ShortInt Short Integer (16-bit) value
SingleFloat Float value (i.e. floating point value vith less value range and precision than Double)
SmallInt Small Integer (16-bit) value
String UTF8-encoded String value
Unknown Default value. Value data type is unknown.

Schema fileds of this type cannot participate in any data access or update operations
WideMemo Unicode-encoded string value. Values of this type are used to store very long strings
WideString Unicode-encoded String value
Word Unsigned Short Integer (16-bit) value.

Currently values of this type aren't fully supported by the Data Abstract for Java as they are serialized and deserialized as signed integers, thus limiting the possible value range
Xml org.w3c.dom.Node. Support is limited.