Re: Language setting problem...

Diviner wrote:

> I am using Oracle8i 8.1.7 for Win2000. And now cannot handle Chinese
> character
> inside Oracle. All the Chinese character becomes question marks "????".
> How to
> fix the problem?
>
> I have:
> - Win2000 in English version.
> - Create database using ZHT16BIG5 as its code setting.
> (choose it from Custom Install page)
> - NLS_LANG environment already set as
> "TRADITIONAL CHINESE_TAIWAN.ZHT16BIG5"
> on both client side and server side(actually both client &
> server are on the same machine at the moment). I have
> verified by SET command, it's fine.
> - Added:
> NLS_LANG = "TRADITIONAL CHINESE"
> NLS_TERRITORY = "TAIWAN"
> into "init.ora" before starting database.
> - Examined the database by:
> "select * from NLS_DATABASE_PARAMETERS"
> and find that two parameters are still leaving English
> setting:
> NLS_LANGUAGE = AMERICAN
> NLS_TERRITORY = AMERICA
> (I wonder why it cannot affect by parameters of init.ora
> and don't know how to change it)
> two parameters value are correct:
> NLS_CHARACTERSET = ZHT16BIG5
> NLS_NCHAR_CHARACTERSET = ZHT16BIG5
> - Examined the database by:
> "show parameters nls"
> So stranger, I find that:
> NLS_LANGUAGE = "TRADITIONAL CHINESE"
> NLS_TERRITORY = "TAIWAN"
> - Tried to connect by Oracle client from NT4 Chinese system, but
> the problem still there.
> - All the Oracle system message(prompt message, error message...etc)
> is changed to Chinese and work well already.
>
> Hope the above information is enough to explain what I wrong in
> the language setting.
>
> --
> Best regards,
> Diviner.

Alter the character set to UTF8. Something you can do in 8.1.7. Also get the patch from Oracle to upgrade to 8.1.7.1.0 as it fixes some UTF8 and other bugs.

Daniel A. Morgan Received on Wed Jun 06 2001 - 01:23:54 CDT