Variable data types
The UNICOM Intelligence Data Model implements variables of the following data types:
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.
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 in 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.
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 might or might not support Unicode, depending on the DSC. The OLE DB Provider implements all strings using Unicode.
See also