Re: inserting non-english strings into oracle table

From: Pierre-Andre Morin <pa-m_at_iname.com>
Date: Thu, 04 Mar 1999 19:23:00 +0900
Message-ID: <36DE5F04.F11C35DF@iname.com>

About the Japanese version you need
1) the database to be created with Japanese 2) the listener to run with Japanese; To do this the /home/oracle/.profile could contain something like NLS_LANG="AMERICAN_AMERICA.JA16SJIS"; 3) the client must run in Japanese; Use the same set-up a previously (in Winxx use the hkey_local_machine/software/oracle/nls_lang key.

Unless the database is in japanese, the client and the server are in Japanese it won't work because Oracle tries to translate from one language to another.

I have also a configuration in Three tier where the middle tier must also have nls_lang setup.

Take care,

Pierre-Andre Morin Received on Thu Mar 04 1999 - 04:23:00 CST