Information Store property value ranges

The Information Store places limits on the ranges of values that properties can contain. Different logical types in the i2 Analyze schema imply different limits, which are not always the same as the restrictions on the underlying database. It is important to consider the limits when you prepare data for ingestion.

Logical type limits that depend on the underlying database

Logical type

SQL Server values

PostgreSQL values

Db2 values

SINGLE_LINE_STRING

Up to 4000 bytes of UTF-16 characters. The default value is 250 *

Up to 8000 bytes of UTF-8 characters. The default value is 250 *

Up to 8000 bytes of UTF-8 characters. The default value is 250 *

MULTI_LINE_STRING

Up to 231-1 bytes of UTF-16 characters

Up to 230 bytes of characters

Up to 32700 bytes of UTF-8 characters

SELECTED_FROM

Same as SINGLE_LINE_STRING

Same as SINGLE_LINE_STRING

Same as SINGLE_LINE_STRING

SUGGESTED_FROM

Same as SINGLE_LINE_STRING

Same as SINGLE_LINE_STRING

Same as SINGLE_LINE_STRING

* The value for SINGLE_LINE_STRING depends on the value that is specified for each property with that type in the i2 Analyze schema.

Logical type limits

Logical type

values

DATE

From 1753-01-01 to 9999-12-31

TIME

From 00:00:00 to 23:59:59 *

DATE_AND_TIME

From 1753-01-01T23:00:00 ** to 9999-12-31T00:00:00

BOOLEAN

true or false

INTEGER

From -231 to 231-1

DOUBLE

From 4.9 x 10-324 to 1.79769313486231 x 10308 (Equivalent range for negative values. Maximum 15 digits of precision.)

DECIMAL

From -999999999999999999.9999 to 999999999999999999.9999 (Maximum 18 digits before the decimal mark. Maximum 4 digits after it.)

GEOSPATIAL

From -180.0000 to 180.0000 for longitude values, and -90.0000 to 90.0000 for latitude values. The data must be in the Well-known text representation, POINT(longitude latitude). The longitude and latitude values must conform to the WGS84 Bounds. For more information about the values, see Spatial reference - WGS84.

* If a Db2 database underlies the Information Store you can load time values that represent midnight as 24:00:00. When it stores such values, the database converts them to fit the ranges in the table.

** The From DATE_AND_TIME value starts at 23:00:00.

Note:

  • Data that includes non-printing or control characters might not be indexed and can cause errors.

  • In addition to the values in the table, you can set the value of any non-mandatory property to null. In the staging table for an item type that has a DATE_AND_TIME property type, all four columns that the value is spread across must be null in that case.