Data Types
Data in an ADOxx-based product is stored in different types. The following section describes the different types, their purpose and their properties.
Character/String data types
These are attribute types that store individual characters (e.g. letters) or strings of characters ("words"). Depending on the use case (e.g. the amount of text to be stored), different attribute types can be used.
| Attribute type | Maximum length | Description |
|---|---|---|
| Longstring | 50000 | To be used for all texts where the expected number of contained characters is high. |
| String | 1300 | To be used for texts where the expected number of contained characters is low |
| Adostring | 3700 | To be used for texts where the expected number of contained characters is low to medium |
| Filepointer | 50000 | Used for attributes that contain a link to a file either in the internal database or to an external source (e.g. via http or https protocol). The entered link can have a length of up to 50000 characters |
Integer data types
These are attribute types that hold numeric integer values (numbers without decimal places).
| Attribute type | Range of values | Description |
|---|---|---|
| Integer | -2147483648 to 2147483647 | Integer attribute type to hold numbers without decimal places |
| Unsigned Integer | 0 to 4294967295 | Unsigned Integer attribute type to hold positive numbers without decimal places |
| Bool | false/true | Boolean attribute type to hold binary values (true or false) |
Floating point data types
These are attribute types that hold numeric values with floating point (numbers with decimal places).
Precision is the number of digits in a number. Scale is the number of digits to the right of the decimal point in a number. For example, the number 123.45 has a precision of 5 and a scale of 2.
| Attribute type | Maximum precision | Maximum scale | Range of values | Description |
|---|---|---|---|---|
| Double | 15 | 6 | -999999999999999 to 999999999999999 | Floating point attribute type hold numbers with decimal places |
| UTC | 15 | 0 | -999999999999999 to 999999999999999 | UTC attribute type to be used for date values. This is internally stored as a double attribute without decimal places. UTC is defined as the number of seconds since 01.01.1970 00:00:00. |
Complex attribute types
In addition to the simple attributes types listed above, there are complex attribute types that are constructed of simple attribute types. A complex attribute type is a table where each column is of a certain simple attribute type. These columns share the properties of the simple attribute type they represent and that are listed in the tables above.