NLS_LANG problems

[Denton Williams]

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.

[Chris Lo · Accepted solution]

It's

AMERICAN_AMERICA.UTF8

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

[Srinivas Sreekumar]

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

[Denton Williams]

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