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
- Reference: RemObjects.DataAbstract.dll
- Namespace: RemObjects.DataAbstract.Schema
| 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 |