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.

With Regards,
S K Mittal

Hi,
JA16SJISTILDE is available only from 9.2
Please use the one japaness character set for your version of oracle

regards
anandkl

use this as ur database character set
JA16SJIS----This is a 16 bit superset

regards
anandkl

Thanks for the useful inputs!!

I was also thinking that the JA16SJISTTILDE was not available in Release 1. Actually I need this character set for NLS_LANG to import the data into the new database I am able to create in JA16SJIS.

Since this is confirmed now I'll have to get on on to download the Rease 2, or is there any other way by which I can apply JA16SJISTTILDE as a patch.

Thanks a ton

S K Mittal

About the patch,
I am not sure, check in metalink, u might some useful info.

regards
anandkl