Need help in setting up Japanese Database
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Need help in setting up Japanese Database

  1. #1
    Join Date
    Feb 2002
    Posts
    70

    Question

    Hi there,

    Help needed in setting up Japanese Database.
    I created database with UTF8 character set on Sun Solaris O/S.
    Oracle version 8.1.7.
    I am accessing the DB through SQL*Plus (Windows client).
    I downloaded the Japanese font on client side and also set the NLS_LANG environment variable to Japanese_Japan.UTF8. Still, I am not able to view Japanese characters. O/S on client side is Windows 2000 professional (English). Is O/S (client) need to be Japanese O/S? When I try to retrieve sysdate, its displaying in Japanese but not all characters in Japanese. Can anyone help me out how to set up the client and is there any parameters to be setup at server side? I also tried to insert japanese characters into table through client, but it displaying as "?????" characters. Any help in this regard is appreciated.

    Thanks in advance,
    -Shankar
    ________________
    ShanDJ

  2. #2
    Join Date
    Jun 2002
    Location
    Denver
    Posts
    54
    We tried two japanese NLS_LANGUAGE settings :

    JAPANESE_JAPAN.AL24UTFFSS and JAPANESE_JAPAN.JA16SJIS (Shift-J's).

    I can't remember which one worked. It's been more than 2 years. But you can try both. Also we had Japanese Windows System to view Japanese characters. I'm not sure if just Japanese fonts would help. The underlying data in the database does not change. It's just how you view it.

    It was important that the character set setting portion of this parameter (e.g. AL24UTFFSS) be the same as that defined during the creation of the database. What needs to change is the LANGUAGE and TERRITORY settings, depending on the data being accessed.

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