Variable data types
The UNICOM Intelligence Data Model implements variables of the following data types:
Double data type
A 64-bit floating-point number with at least 15 digits of precision.
Long data type
A 32-bit signed integer.
Text data type
A character string. The maximum length is dependent on the DSC being used to read the data and the underlying data format. Strings may or may not support Unicode, depending on the DSC. The OLE DB Provider implements all strings using Unicode.
Categorical data type
A single or multiple categorical response type. The maximum number of responses available varies between DSCs. A categorical response is implemented as a string, in which the responses are formatted within braces, ({ }), with each response delimited by a comma. For example, {2,3,8} represents the responses 2, 3, and 8. Depending on how the data was collected, the order of the responses in the string can be the order in which they were chosen in response to the question.
Date data type
A 64-bit OLE Date, which contains both date and time.
Boolean data type
A Boolean value of either True or False. When a Boolean is converted to a Long or a Double, it is converted to 1 for True and 0 for False.
See also