-
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
anandkl
-
anandkl
use this as ur database character set
JA16SJIS----This is a 16 bit superset
regards
anandkl
anandkl
-
any patch for JA16SJISTTILDE
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
anandkl
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|