0

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.

asked Mar 31, 2014 at 8:53
2
  • What command-line tools? What operating system? What scripting language? Should be fine if the NLS settings are correct. Commented Mar 31, 2014 at 9:13
  • @GrumpyPhil Thank you your comment, I extended the question with the needed infos. Commented Mar 31, 2014 at 9:29

1 Answer 1

1

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. :-)

answered Mar 31, 2014 at 10:06

Your Answer

Draft saved
Draft discarded

Sign up or log in

Sign up using Google
Sign up using Email and Password

Post as a guest

Required, but never shown

Post as a guest

Required, but never shown

By clicking "Post Your Answer", you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.