IBM Support

Special characters are not transfered correctly and appear as square characters in SQLTerm

Troubleshooting


Problem

Special characters on the source table are not copied correctly to the target table and appear as square characters when viewed through SQLTerm. For example, the character string ł Ź ś Ž Ğ Ã Œ Ç Æ Å Ã Ý ü Ą Ć is written to the target table and appears in SQLTerm as � � � Ž � à Œ Ç Æ Å Ã Ý ü � � The same problem does not occur when transferring via the bulk loader and UTF8 is specified.

[{"Product":{"code":"SSEP7J","label":"Cognos Business Intelligence"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"Data Manager","Platform":[{"code":"PF033","label":"Windows"}],"Version":"8.3","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}},{"Product":{"code":"SSEP7J","label":"Cognos Business Intelligence"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"Data Manager","Platform":[{"code":"PF033","label":"Windows"}],"Version":"8.3","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}},{"Product":{"code":"SS6G84","label":"IBM Cognos Analytics on Cloud"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":" ","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}}]

Log InLog in to view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

Historical Number

1040641

Document Information

Modified date:
08 May 2025

UID

swg21343177