Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2003
    Posts
    5

    Question Unanswered: Chinese characters in the database

    hi all!

    My database contains simplified chinese chars. when i view table contents via Enterprise Manager -> open table, all data is ok.

    now i have to display it via ASP scripts. and there everything gets screwd up. i get ? marks instead of the chinese chars.

    any idea?

  2. #2
    Join Date
    Jan 2003
    Location
    India
    Posts
    523
    check if chinese is installed on u'r m/c and what are u'r default settings ,
    check the locale settings of the machine.

  3. #3
    Join Date
    Jul 2003
    Location
    Penang, Malaysia
    Posts
    212
    In your ASP pages, you need to check your codec

    I'm not sure if this is u'r case, but maybe u could try this asp code in your asp script

    Code:
    Depends on your Chinese Char Type either
    
    Response.CodePage = 936
    Response.CharSet = "GB2312"
    
    or
    
    Response.CodePage = 950
    Response.CharSet = "big5"
    Then the data u select out from your MS SQL Database should be able to be viewed, and proceed with normal coding.


    If this happens to be related to u'r problem, u might want to search the net to know more about this "codepage" and "charset" attributtes.

    Hope this helps.
    Last edited by Patrick Chua; 09-24-03 at 09:29.
    Patrick Chua
    LBMS ( Learn By My Self) NPQ ( No paper Qualification )

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •