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 126.96.36.199.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.
S K Mittal