home *** CD-ROM | disk | FTP | other *** search
- Path: sparky!uunet!europa.asd.contel.com!darwin.sura.net!mips!pacbell.com!pacbell!oracle!unrepliable!bounce
- Newsgroups: comp.databases.oracle
- From: kjou@us.oracle.com (Kathy Jou)
- Subject: Re: National Language Support in ORACLE v.6
- Message-ID: <1992Jul28.172537.8294@oracle.us.oracle.com>
- Followup-To: kjou@us.oracle.com
- Sender: Kathy Jou
- Nntp-Posting-Host: hqpyr1.us.oracle.com
- Organization: Oracle Corporation, Redwood Shores CA 94065
- References: <1992Jul23.132010.2226@rz.uni-karlsruhe.de> <1992Jul28.121659.6252@rz.uni-karlsruhe.de>
- Distribution: comp.databases.oracle
- Date: Tue, 28 Jul 1992 17:25:37 GMT
- X-Disclaimer: This message was written by an unauthenticated user
- at Oracle Corporation. The opinions expressed are those
- of the user and not necessarily those of Oracle.
- Lines: 43
-
- In article <1992Jul28.121659.6252@rz.uni-karlsruhe.de> rz34@rz.uni-karlsruhe.de writes:
- >In article <1992Jul23.132010.2226@rz.uni-karlsruhe.de> rz34@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
-
-