topic Re: NLS_LANG problems in Operating System - HP-UX

NLS_LANG problems

Denton Williams — Fri, 18 Jan 2002 19:34:52 GMT

Hi All,
I am having problems with my NLS_LANG when I try to connect to Oracle. I have it set in my .profile as follows:
NLS_LANG=AMERICAN-AMERICAN.USF8

When I try to connect it says that it does not recognize the NLS_LANG. Where can I find the language set of my HP Unix 11 system? Is it set anywhere else apart from my .profile?

Thanks,
Dee.

Re: NLS_LANG problems

Chris Lo — Fri, 18 Jan 2002 19:40:33 GMT

It's

AMERICAN_AMERICA.UTF8

instead...if you want to be
able to store double byte character...

Re: NLS_LANG problems

Srinivas Sreekumar — Fri, 18 Jan 2002 19:59:28 GMT

replace you line in .profile with the below one and try

export NLS_LANG= AMERICAN_AMERICA.UTF8

Or else open a session and explicitly run the above on your prompt and try.

Srini

Re: NLS_LANG problems

Denton Williams — Fri, 18 Jan 2002 20:40:03 GMT

Thanks Guy's you saved me tonnes of brain cells.