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 | Db2 values | SQL Server values |
---|---|---|
SINGLE_LINE_STRING |
Up to 8000 bytes of UTF-8 characters. The default value is 250.* | Up to 4000 bytes of UTF-16 characters. The default value is 250.* |
MULTI_LINE_STRING |
Up to 32700 bytes of UTF-8 characters | Up to 231-1 bytes of UTF-16 characters. |
SELECTED_FROM |
Same as
SINGLE_LINE_STRING |
Same as
SINGLE_LINE_STRING |
SUGGESTED_FROM |
Same as
SINGLE_LINE_STRING |
Same as
SINGLE_LINE_STRING |
DATE |
From 1753-01-01 to 9999-12-31 | From 1753-01-01 to 9999-12-31 |
TIME |
From 00:00:00 to 23:59:59 ** | From 00:00:00 to 23:59:59 |
DATE_AND_TIME |
From 1753-01-01T00:00:00Z to 9999-12-31T23:59:59Z ** | From 0001-01-01 00:00:00.00Z to 9999-12-31 23:59:59.99Z |
BOOLEAN |
true or
false |
true or
false |
INTEGER |
From -231 to 231 - 1 | 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.) |
From - 1.79E+308 to -2.23E-308, 0 and
2.23E-308 to 1.79E+308 (Maximum 17 digits of precision.) |
DECIMAL |
From -999999999999999999.9999 to
999999999999999999.9999 (Maximum 18 digits before the decimal mark. Maximum 4 digits after it.) |
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. |
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. |
* The value for
SINGLE_LINE_STRING
depends on the
value that is specified for each property with
that type in the i2 Analyze schema.
** 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.
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.