Home » SQL & PL/SQL » SQL & PL/SQL » NLS Character Issue (Oracle 10.2.0.4.0 ; OS - Unix)
NLS Character Issue [message #424238] Thu, 01 October 2009 01:02
keen_2_learn_oracle
Messages: 1
Registered: October 2009
Junior Member
Hi,

In my current application, I am generating flat files using UTL_FILE package (Oracle utilty). There is a character "¥", we are using as a delimiter. This value is stored in a lookup table. In the application procedure we select the database fields and concatenate it with the delimiter (selected from the lookup table and assigned to a variable)

This works fine in the development environment.

However when this was deployed in the Production env, we are getting the following issues

1. In the Unix file The delimiter is appended with a special character. i.e "Â¥" instead of "¥".

2. Some special characters are getting replaced. For e.g. Ö is replaced with Ã. So a word DÖH appears as DÃH

To resolve this, we ran the following Unix commands

NLS_LANG="ENGLISH_UNITED KINGDOM.UTF8"
export NL_LANG

But the issue is still persisting.

Any suggestion / comments to resolve the issue are welcome.

Thanks,
Ashish
Previous Topic: sum of time
Next Topic: not sure what the nvl() function is replacing here...
Goto Forum:
  


Current Time: Sun Dec 11 08:10:48 CST 2016

Total time taken to generate the page: 0.07311 seconds