Print

Use this chart to understand which data types can be converted to other data types and if there are any ramifications. The ability to convert depends on the current index field values entered. While most of the information on this chart are SQL Server constraints, it applies to both ILINX Capture and ILINX Content Store index values.

As an example, if you wish to convert a string type to an integer, and a value currently applied to a document is “PO 42”, the conversion will fail. Once the value is modified to match the new type, or emptied, the conversion will be successful.

Warning: When converting data types there is always a chance to lose or corrupt data.  Do this only if completely necessary.

Note: A picklist data type cannot be converted to any other data type.

 

[table class= “table-striped” terminator = “|” nl=”~~”]

Current Type, Target, Available, Comment|

String, Integer, Yes, If there is any current value other than an integer\, the modification will fail. Once all values meet the integer format\, modification will succeed.|

String, Date, Yes, If any current value is other than a date format\, modification will fail. Once all values meet date format\, modification will succeed.|

String, Decimal, Yes, Assumes this index field is void of any values or current values meet the decimal specification.|

String, Picklist, Yes, All current values will be honored\, and the converted value available for that document only.|

Integer, String, Yes, Once modified\, all values will appear as originally entered. If\, when converting to a string\, the maximum length is less than an entered integer value\, the new value will be an asterisk (*).|

Integer, Date, Yes, Assumes this index field is void of any values or a value exists that can be interpreted to a date value. After conversion\, values may have to be updated. As an example\, if the index field had 1 as its value\, when converted to date type\, the value is now 1/2/1900.|

Integer, Decimal, Yes, Once modified to decimal\, any current integer value will convert with zeroes in the decimal position.|

Integer, Picklist, Yes, All current values will be honored\, and that value will be available in the picklist for that document only.|

Date, String, Yes, Once modified to string\, any currently entered date value will be converted.  As an example\, if the date value was 10/10/2001\, upon change\, this value now becomes Oct 10 2001 12:00AM.|

Date, Integer, No, An error message will appear when this conversion is attempted.|

Date, Decimal, No, An error message will appear when this conversion is attempted.|

Date, Picklist, Yes, Once modified to picklist\, any currently entered value will be converted and created outside of the picklist values. As an example\, if the date value was 10/10/2001\, upon change\, this value now becomes Oct 10 2001 12:00AM.|

Decimal, String, Yes, Once modified\, all values will appear as originally entered\, including decimal values. If\, when converting to a string and the maximum length is less than an entered decimal value\, an error message will appear. Be sure to make the maximum length fit for the current values.|

Decimal, Integer, Yes, Once modified to integer\, any decimal value will be dropped.|

Decimal, Date, No, Will convert but data is not useable after conversion.|

Decimal, Picklist, Yes, Once modified to picklist\, any currently entered value will be converted and created outside of the picklist value.|

[/table]