Hello,

I have copied one of the oracle instance into some other server, now the NLS i would like to change it to Simplified CHINESE, i have already done changes in db_resource file by specifiying


Korean Korean_korea.ko16ksc5601


now i need to do the same thing at oracle database level, how do i do it at oracle database level, i am running Oracle 9i on hp unix.

any links or posts ??

Waiting for your reply.

Regards

Learner

Hi learner,

I am a bit confused here: Are we talking korean or chinese?

Apart from this, normally you set the characterset of an oracle instance, before you create it. So copying one and changing the characterset can be done technically, it causes some headache for the data which is already present. Oracle permits it only if the new characterset is a superset of the old, for example the WE charactersets are a superset of US7ASCII (on the binary level).

Anyway, operating a multibyte installation in Ban is causing enough NLS and TTS problems. So advise you to create the oracle instance from scratch with the right charactersets. Otherwise troubleshooting will become difficult for you in the future.

Regards

Markus

Hi,

Sorry for the confusion, actually i was quered wrong system.

i need to set to chinese, i again checked with my dba he said he did a fresh installation

following r the parameters in my system

1) db_resource file in baan
nls_lang:AMERICAN_AMERICA.zhs16cgb231280

2) bw file
changed to Simplified Chinese

3) use local set via User Data template
GB_HPUX10.0

4) select * from v$nls_parameters;

NLS_CHARACTERSET - ZHS16CGB231280
NLS_NCHAR_CHARACTERSET - AL16UTF16

anything else which we have to do ?? do i need to install B-Language support or some particular solution for CHINESE ?


Waiting for your reply.

Regards

Learner