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.

Cause

The Oracle client NLS_LANG parameter in the registry does not match the NLS_DATABASE_PARAMETER values in the Oracle database.

Environment

Oracle

Resolving The Problem

If on running

select * from nls_database_parameters on the database, the following is returned

NLS_LANGUAGE = AMERICAN
NLS_TERRITORY = AMERICA
NLS_CHARACTERSET = UTF8

then NLS_LANG should be set to match i.e. AMERICAN_AMERICA.UTF8

Steps:Create a system variable called NLS_LANG and set it appropriately to match the NLS parameters in the database. The machine needs to be rebooted for the system variable to take effect.

[{"Product":{"code":"SSEP7J","label":"Cognos Business Intelligence"},"Business Unit":{"code":"BU053","label":"Cloud \u0026 Data Platform"},"Component":"Data Manager","Platform":[{"code":"PF033","label":"Windows"}],"Version":"8.3","Edition":"","Line of Business":{"code":"","label":""}},{"Product":{"code":"SSEP7J","label":"Cognos Business Intelligence"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Data Manager","Platform":[{"code":"PF033","label":"Windows"}],"Version":"8.3","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Historical Number

1040641

Was this topic helpful?

Document Information

Modified date:
28 November 2022

UID

swg21343177

Tips