Open topic with navigation
Unicode Text Adapter Data Types
The Unicode Text Adapter
supports the following data types:
- text
— String data with a known maximum length. For variable length text fields,
use memo.
- integer
– Any positive or negative whole number. Fractional data will be truncated.
- decimal
– Numeric data up to 29 (or 28 with a negative sign) digits that includes
precision.
- float
– Numeric data up to 16 (or 15 with a negative sign) digits that includes
precision.
- boolean
– Data that returns either True or False. Insight also accepts 1 (True)
and 0 (False) as input.
- datetime
– Data that represents a date and/or time. See Date/Time
Formats with the Unicode Text Adapter for more information.
- memo
– String data of any length. Use memo data to store BLOB (Binary Large
OBject) or other large amounts of string data.
Note: While you can
change the data type, doing so may cause unexpected results.