Skip to main content
Question

Change NLS_LANG on Oracle Instant Client.


Forum|alt.badge.img+14

Hi all,

We are running PL/SQL Developer on our Windows clients with Oracle Instant Client. When doing so, the packages cannot handle Nordic characters (æøå). I think I have identified the problem as the NLS_LANG value in registry.  I have an old installation that is working. It looks like this:

 

On Instant Client theses entries does not exists (default is AMERICAN_AMERICAN.US7ASCII).

SELECT distinct client_charset FROM v$session_connect_info
WHERE sid = sys_context('USERENV','SID');

Anyone know an easy way to change NLS_LANG?

 

2 replies

Forum|alt.badge.img+21
  • Superhero (Employee)
  • 427 replies
  • May 29, 2020

Hi Hans,

 

Have you tried setting the NLS_LANG in the Windows Environment variables as a system variable? Should work quite similar to the way the registry entry is working.

Cheers


Forum|alt.badge.img+14
  • Author
  • Hero (Partner)
  • 241 replies
  • May 29, 2020

Thanks @Sajith D , it worked.

For the ones facing the same problem.

Find the NLS_LANG on the server.

Combine it into this:

AMERICAN_AMERICA.AL32UTF8

Add it to the environment on the clients:

 


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings