Re: National Language Support in ORACLE v.6

In article <1992Jul28.121659.6252_at_rz.uni-karlsruhe.de> rz34_at_rz.uni-karlsruhe.de writes:
>In article <1992Jul23.132010.2226_at_rz.uni-karlsruhe.de> rz34_at_rz.uni-karlsruhe.de writes:
>>We're using ORACLE version 6.0.34.2.1 on an HP-UX Series 9000/800.
>>
>>I'm trying to get National Language Support to work and can't.
>>I've followed the instructions in the DBA Guide, i.e. I added
>>
>>nls_sort = true
>>germany_germany.WE8HP
>>
>>to init.ora. Am I using the wrong character set?
>>Can anyone help?
>>
>>Thanks!
>>Karen
>
>Thanks again to those who replied. Everyone told me to change
>language=germany_germany.we8hp
>to
>language=german_germany.we8hp
>
>which I tried. I also tried different combinations of upper and lower
>case. Still no luck. Any other suggestions?
>
>Karen

Did you restart the datbabase after making the change to the init{SID}.ora file? From sqldba, after you connect internal or to system, issue "show parameter language". Does it reflect what you have entered (just in case it was placed in the wrong init ora file)?

In order to receive German error messages, you also need to set the LANGUAGE environment variable to the same value as language in the init ora file. The wrong character set will only limit you to what type of characters you may enter, not the language. The appendix of the DBA guide talks about this in a little more detail. Also check for online readme files regarding supported character sets on HP/UX.

Regards,

Kathy Jou
Oracle Corporation Received on Tue Jul 28 1992 - 19:25:37 CEST