Description: TEXT stores stores any text values.
Range: Any utf-8 encodable sequence of characters with maximal 65,535 bytes. (Simply put: In most cases, any text with less than 65,535 letters and spaces will work. But if you use special characters like
€or non-latin letters then the number of bytes, which are needed to store it, increases. Then the effective maximal length is smaller than 65,535. A bad case scenario would be a text in Chinese. Chinese characters need about three times the space of letters from the latin alphabet. Therefore, only 21845 Chinese characters can be stored within this datatype. Which is still quite a lot I guess :D)
Am Faßberg 17, D-37077 Göttingen, Germany
Experiment went well until the problem with the voltmeter occured. Don't use the results after that.
Abstract: bla bla bla ...
Head of Group
A. Schlemmer, S. Berg, TK Shajahan, S. Luther, U. Parlitz, Quantifying Spatiotemporal Complexity of Cardiac Dynamics using Ordinal Patterns, 37th Annual International Conference of the IEEE Engineering in Medicine and Biology Society (EMBC), 2015, doi: 10.1109/EMBC.2015.7319283
Description: BOOLEAN stores boolean
FALSE. It is therefore suitable for any variable that represents that something is the case or not.
FALSE, case insensitive (i.e. it doesn’t matter if you use capitals or small letters).
Note: You could also use a TEXT datatype to represent booleans (or even INTEGER or DOUBLE). But it makes a lot of sense to use this special datatype as it ensures that only the two possible values,
FALSEare inserted into the database. Every other input would be rejected. This helps to keep the database understandable and to avoid mistakes.
Description: INTEGER stores integer numbers. If you need floating point variables, take a look at DOUBLE.
-0is interpreted and stored as
Note: This rather limited range is just provisional. It can be extended with low effort as soon as requested.
Description: DOUBLE stores floating point numbers with a double precision as defined by IEEE 754.
1.7976931348623157E308(negative and positive) with a precision of 15 decimals.
Any other decimal number might work but it is not guaranteed.
Note: The server generates a warning when the precision of the submitted DOUBLE value is to high to be preserved.
The DateTime data type exists in (currently) three flavors which are dynamically chosen during parsing on the serverside. The flavors have different ranges, support of time zones and intended use cases. Only the first two flavors are actually implemented for storage and queries. The third one is implemented for queries exclusively.
Description: This DATETIME flavor stores values which represent a single point of time according to UTC with the format specified by ISO 8601 (Combined date and time). It does support UTC Leap Seconds and time zones.
9999-12-31T23:59:59.999999999UTCwith nanosecond precision.
2016-01-01T13:23:00.0CESTwhich means January 1, 2016, 1:23 PM, Central European Summer Time.
-800-01-01T13:23:00.0which means January 1, 800 BC, 1:23 PM, UTC.
It is allowed to ommit the nanosecond part of a UTCDateTime (
2016-01-01T13:23:00CEST). This indicates a precision of seconds for a UTCDateTime value.
Description:: This DATETIME flavor stores values which represent a single date, month or year according to the gregorian calendar. A month/year is conceived as a single date with the presion of a month/year. This concept is useful if you try to understand the query semantics which are explained elsewhere.
Y[YYY][-MM[-dd]] (where square brackets mean that the expression is optional).
Range:: Any valid date according to the gregorian calendar from
9999-12-31 (and respective dates with lower precision. E.g. the year
-9999). There is no year
Note: Date is a specialization of [#SemiCompleteDateTime].
Description: A generalization of the Date and UTCDateTime flavors. In general, there is no time zone support. Although this flavor is not yet storable in general, it is implemented for search queries yet. I.e. you might search for
FIND ... date>2015-04-03T20:15yet.
Special Properties: For every SemiCompleteDateTime d there exists a Inclusive Lower Bound (
d.ILB) and a Exclusive Upper Bound (
d.EUB). That means, a SemiCompleteDateTime can be interpreted as an interval of time. E.g.
2015-01is the half-open interval
[2015-01-01T00:00:00.0, 2016-01-01T00:00:00.0). ILB and EUB are UTCDateTimes respectively. These properties are important for the semantics of the the query language, especialy the operators.
Please file a new feature request as soon as you need them.
Time:: For a time of the day (without the date). Supports time zones.
FragmentaryDateTime:: For any fragmentary DateTime. That is an arbitrary combination of year, month, day of week, day of month, day of year, hour of day, minute, seconds (and nanoseconds). This flavor is useful for recurrent events like a bus schedule (Saturday, 7:30) or the time of a standing order for money transfer (third day of the month).
Description: REFERENCE values store the Valid ID of an existing entity. The are useful to establish links between two entities.
After beeing processed successfully by the server the REFERENCE value is normalized to a Valid ID. I.e. it is guaranteed that a REFERENCE value of a valid property is a positive integer.
Description: A FILE is a special REFERENCE. It only allows entity IDS which belong to a File.
RecordType as a data type
Furthermore, any RecordType can be used as a data type. This is a variant of the REFERENCE data type where any entity is a valid value which is a child of the RecordType in question.
Personbe a RecordType,
Bertrand Russelbe a child of
Bertrand Russelis a valid value for a property with a
Description: A LIST is always a list of something which has another data type. E.g. A LIST of TEXT values, a LIST of REFERENCES value, etc. Here we call TEXT resp. REFERENCE the Element Data Type. The LIST data type allows you to store an arbitrary empty or non-empty ordered set (with duplicates) of values of the same data type into one property. Each value must be a valid value of the Element Data Type.
LIST of INTEGER:
[0, 2, 4, 5, 8, 2, 3, 6, 7]
LIST of Person, while
Personis a RecordType:
['Bertrand Russel', 'Mahatma Ghandi', 'Mother Therese']