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

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

export NL_LANG

But the issue is still persisting.

Any suggestion / comments to resolve the issue are welcome.

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

Current Time: Tue Jan 17 19:51:32 CST 2017

Total time taken to generate the page: 0.44447 seconds