If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Character Set

Hi,

I want to create a Japanaese database using JA16SJISTILDE characterset. But the enviroment variable NLS_LANG when set to Japanese_Japan.JA16SJISTILDE doesn't allow to login to SQLPlus saying Invalid Characterset (ORA:12705)
So thinking that this might not a valid Value for NLS_LANG I set it to Japanese_Japan.JA16SJIS and was thus able to get into the SQLPlus now to create the database.

But now when issue:

Create Database ...
....
CHARACTER SET JA16SJISTILDE
NATIONAL CHARACTER SET al16utf16set;

it again gives the similar error message (ORA-12701)

I'm using Oracle 9i Release 1 (Oracle9i Enterprise Edition Release 9.0.1.1.1) on Windows 2000.
I am not able to ascertain why it is not recognising
JA16SJISTILDE as a valid value both at Database and Enviroment level,
when its mentioned in the documents

I have set Japanese Locale settings using Windows Control Panel> Regional Options, so much that the menus etc are now capable of displaying in Japanese. Installation of Oracle also went in Japanese.