DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Character Set

  1. #1
    Join Date
    Nov 2000
    Location
    New Delhi, India
    Posts
    81

    Question 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

  2. #2
    Join Date
    Aug 2001
    Location
    chennai,bangalore
    Posts
    840
    Hi,
    JA16SJISTILDE is available only from 9.2
    Please use the one japaness character set for your version of oracle

    regards
    anandkl
    anandkl

  3. #3
    Join Date
    Aug 2001
    Location
    chennai,bangalore
    Posts
    840

    anandkl

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

    regards
    anandkl
    anandkl

  4. #4
    Join Date
    Nov 2000
    Location
    New Delhi, India
    Posts
    81

    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

  5. #5
    Join Date
    Aug 2001
    Location
    chennai,bangalore
    Posts
    840
    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
  •  


Click Here to Expand Forum to Full Width