Skip to main content
Version: ADONIS 14/ADOIT 15/ADOGRC 11.2

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 typeMaximum lengthDescription
Longstring50000To be used for all texts where the expected number of contained characters is high.
String1300To be used for texts where the expected number of contained characters is low
Adostring3700To be used for texts where the expected number of contained characters is low to medium
Filepointer50000Used 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 typeRange of valuesDescription
Integer-2147483648 to 2147483647Integer attribute type to hold numbers without decimal places
Unsigned Integer0 to 4294967295Unsigned Integer attribute type to hold positive numbers without decimal places
Boolfalse/trueBoolean 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).

note

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 typeMaximum precisionMaximum scaleRange of valuesDescription
Double156-999999999999999 to 999999999999999Floating point attribute type hold numbers with decimal places
UTC150-999999999999999 to 999999999999999UTC 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.