I am using a german oracle 11.2.0g install, which has some command line tools communicating with some non-ascii characters (ü, ö, etc.). These are written out in iso8859-1 encoding, but I need them as utf-8 for some scripting. Is it possible?

Additional info:

  • OS: german windows 7 x64
  • Tools: command line tools in the bin/ directory of the oracle install, f.e. lsnrctl and like
  • Scripting language: mostly cmd.exe

Language-specific output is okay, it gives the german output without any problem. The only problem is that it comes in iso8859-1 and not in utf-8.

It were converted by an iconv command from a cygwin, but I used this only as a last resort. The best were if I were able to set somehow the utf-8.

Another tools (f.e. tools from cygwin) work without any problem.

  • What command-line tools? What operating system? What scripting language? Should be fine if the NLS settings are correct. – Philᵀᴹ Mar 31 '14 at 9:13
  • @GrumpyPhil Thank you your comment, I extended the question with the needed infos. – peterh - Reinstate Monica Mar 31 '14 at 9:29

Thank you very much - I found the solution.

First, the output encoding of the Oracle command line tools can be controlled by

  • either the NLS_LANG environment variable (in my situation, a value of GERMAN_GERMANY.AL32UTF8 was needed)
  • or through the registry by the key HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\NLS_LANG

Thank you very much for all - I leave this question to make the googlers of the future happier. :-)

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.