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 .NET 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 .NET (like 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 Decimal value
Cursor Reserved. Not supported yet
DateTime DateTime value
Decimal Decimal value
FixedChar UTF8-encoded String value
FixedWideChar Unicode-encoded String value
Float Double value
Guid GUID value
Integer Integer (32-bit) value
LargeAutoInc Long Integer (64-bit) value that is auto-incremented by the database server. Table fields of this type cannot be updated
LargeInt Long Integer (64-bit) value
LargeUInt Unsigned Long Integer (64-bit) value

Currently values of this type aren't fully supported by the Data Abstract for .NET as they are serialized and deserialized as signed integers, 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 Single value (ie 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 .NET as they are serialized and deserialized as signed integers, thus limiting the possible value range
Xml Reserved. Not supported yet