American_america.utf8 Vs American_america.zhs16gbk
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: American_america.utf8 Vs American_america.zhs16gbk

  1. #1
    Join Date
    Aug 2000
    Location
    Shanghai
    Posts
    433

    American_america.utf8 Vs American_america.zhs16gbk

    We build procedure in AMERICAN_AMERICA.ZHS16GBK and some comments are in Chinese language .

    Now we set the NLS_LANG to AMERICAN_AMERICA.UTF8 , But those
    Chinese characters are displayed as massive code ?

    I thought UTF8 should be able to display properly for any languages?

    Appreciate very much to have your expertised idea .
    1. www.dbasupport.com
    2. www.dbforums.com
    3. www.itpub.net
    4. www.csdn.net
    5. www.umlchina.com
    6. www.tek-tips.com
    7. www.cnforyou.com
    8. fm365.federal.com.cn
    9. www.programmersheaven.com
    10.http://msdn.microsoft.com/library/default.asp
    ligang1000@hotmail.com

  2. #2
    Join Date
    Sep 2003
    Location
    over the hill and through the woods
    Posts
    995
    you left out one important link in your signature..METALINK Try it! It does a DBA good.
    Oracle it's not just a database it's a lifestyle!
    --------------
    BTW....You need to get a girlfriend who's last name isn't .jpg

  3. #3
    Join Date
    Aug 2000
    Location
    Shanghai
    Posts
    433
    Difficult to have an account
    1. www.dbasupport.com
    2. www.dbforums.com
    3. www.itpub.net
    4. www.csdn.net
    5. www.umlchina.com
    6. www.tek-tips.com
    7. www.cnforyou.com
    8. fm365.federal.com.cn
    9. www.programmersheaven.com
    10.http://msdn.microsoft.com/library/default.asp
    ligang1000@hotmail.com

  4. #4
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    another one, my god - you are a dba at a company and have no access to metalink?

  5. #5
    Join Date
    Nov 2004
    Posts
    2
    As I know (I don't know why)
    Even Oracle say UTF8 support chinese character, but actually if I run in UTF8, I cannot input chinese into oracle db.
    So it is better keep use ZHS16GBK and also change your client side nls_lang=american.zhs16gbk

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