NLS Problems - help

Hi,

I've been asked to set up four mchines with their own databases, each in a different Asian language. I got Solaris 8 and the Oracle Software installation in each of the languages to complete successfully.

When I create the DB I needed to set up two environment variables, NLS_LANG and ORA_NLS33. This went smoothly for Japanese and Korean.

My problem is with two of the languages (Simplified and Traditional Chinese). According to the Docs, you set it up as Language_Territory.CharSet. So I've tried:

   zhs_CHINA.ZHS16GBK SIMPLIFIED_CHINESE_CHINA.ZHS16GBK

of which the first should have worked. The tool dbassist, though, each time claims that NLS_LANG is incorrectly set.

In desperation I've tried:

   zhs.ZHS16GBK SIMPLIFIED_CHINESE.ZHS16GBK

Has anyone been able to set up a DB with these two languages (I'm having the same problems with traditional) ??

Just the values, ma'am, just the values.

        -Detective Joe Friday

Thanks in advance,
-Dirk Received on Mon Aug 06 2001 - 20:17:35 CDT