Since computed items are new data items, confirm or change the data type of the item to preserve the precision of a mixed-data type computations, or to change the way a data item is handled (for example, interpreting number as strings). This ensures the correct handling of data in server computations.
Attention to data types is most important when computing items in the Query section. Here the computation is performed on the database server, and the computed item may be handled with an unanticipated data type.
Local calculations (Results or Pivot) are handled internally, and adjustment between 16- and 32-bit integers can be handled safely using the automatic or number data type specification.
Since computed items are new data items, confirm or change the data type of the item to preserve the precision of a mixed-data type computations, or to change the way a data item is handled (for example, interpreting number as strings). This ensures the correct handling of data in server computations.
Local calculations (Results or Pivot) are handled internally, and adjustment between 16- and 32-bit integers can be handled safely using the automatic or number data type specification.
Table 26. Data Type Specifications
A data type is determined automatically given the data type of the reference items and the computations performed | |
| Binary large object which is truncated at 64,000 bytes. Blob data types can include image formats such as: jpeg, bmp, gif, and png. | |
| Variable data type of length determined by a single byte of computer storage. Bytes can store numeric values from 0 to 255, or a single text character | |
| Calendar date in server default format (typically mm/dd/yy) | |
| Retains a 16-bit value (2 bytes). A 16-bit integer stores integer values from 0 to 16,777,216, and signed integers between +8,388,608 and –8,388,608 | |
| Retains a 32-bit value (4 bytes). A 32-bit integer has a range of 0 to 4,294,967,296 if unsigned. If signed, -2,147,483,648 to 2,147,483,647. | |
| Character data (long text) exceeding 255 bytes (use the string data type for text strings up to 255 characters). The maximum long text retrieved is 4000; characters anything greater than that is silently truncated | |
| Real numbers packed for use with EDA middleware. The results in Interactive Reporting are the same as real numbers | |
| Decimal numbers up to 5 positions right of the decimal | |
| Text strings to a maximum length of 256 characters | |
| Time in format set by user preference | |
| Date/time combination in format set by user preference |