iNTERFACEWARE™ Inc.

What Data Type Should I Use in Chameleon to Handle SQL Server Text Types?

Chameleon and Iguana can both easily handle the SQL Server Text type for large strings. This is useful if messages contain multiple paragraphs and/or long diagnoses.

To force Chameleon to handle large strings for a specific field:

• In the Workspace, double-click the table that contains field you want to modify. The Table Definition window opens.

Observation Results Table

• Locate the field that you want to modify, and change its Data Type to String. This will ensure that large strings will not be truncated.

Changing the Data Type

	Try testing your message using the Message Browser to verify that fields containing large strings are correctly being mapped and parsed. For more information, see Message Browser.