This topic is locked

Ploblem in Chinese

10/29/2008 10:57:56 AM
ASPRunnerPro General questions
R
robin author

I'm trying asprunner 6.0 build 507, and find ploblem in chinese.
I use Access 2003 database

  1. If I choose language="Chinese" and Region="Chinese(PRC)".

    The language is chinese,I can show chinese words in database,

    But cannot Add/Update Chinese words into database.
  2. If I choose language="English" and Region="English",

    I can show/Add/Update chinese words into database.

    But the language is english.
    Is this a bug? What can I do ? <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=question&id=10013&image=1&table=forumtopics' class='bbc_emoticon' alt=':(' />
    A post before say that: Database user utf-8, and asprunner use gb2312,is not much.

    but I cannot set Access Database to gb2312, and canot set aspruuner to utf-8.

R
ringah 10/29/2008

I'm trying asprunner 6.0 build 507, and find ploblem in chinese.

I use Access 2003 database

  1. If I choose language="Chinese" and Region="Chinese(PRC)".

    The language is chinese,I can show chinese words in database,

    But cannot Add/Update Chinese words into database.
  2. If I choose language="English" and Region="English",

    I can show/Add/Update chinese words into database.

    But the language is english.
    Is this a bug? What can I do ? <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=34511&image=1&table=forumreplies' class='bbc_emoticon' alt=':(' />
    A post before say that: Database user utf-8, and asprunner use gb2312,is not much.

    but I cannot set Access Database to gb2312, and canot set aspruuner to utf-8.


Generally you will need to (if not already done):
Set Windows to input Chinese Chars - see http://support.microsoft.com/kb/309360
Set Access to accept Chinese chars - http://office.microsoft.com/en-us/access/HP052558321033.aspx
Or if you are trying to enter chinese chars in your browser you need to make sure you have an IME, and set Regional Settings for required type of chinese in PHPR/ASPR | Miscellaneous Tab. UTF8 is OK if you want Eng/Chi chars, BIG5 if just Chinese.
MingLiu.ttf is a suitable general font but you may want to install some other chinese fonts (google)..
From a quick read of the above if you can enter Chinese chars via your browser say to googel search, and can enter Chinese Chars into access and display them ? then the problem is getting them from your browser into access - maybe codepage issue - double check PHPR/ASPR regional settings and try the different chinese options to see if that helps...
You could also try setting the browser regional setting to force chinese (BIG5)..
Hope this helps

R
robin author 10/30/2008

Thank you for your help.

But that not match my ploblem.
I'm using chinese windowsXP (GB2312).

So there have no ploblem in input / display chinese char.
I create a simple Microsoft Access database with only one table.

I can insert chinese char in Access. but cannot insert chinese char in asprunner webpage.
I don't know what should I do to insert chinese record.

G
gemini 10/30/2008

You can do it like so:
open dbcommon.asp, change following sentences:

cCharset = "utf-8"

Session.LCID = 2052

session.codepage=65001
save dbcommon.asp
open templates folder

add <meta http-equiv="Content-Type" content="text/html; charset=utf-8"> before {BEGIN style_block} for all files
then you can view / edit / update the db
Hope it will be useful for you!
Hope xlinesoft can solve this problem, thanks

R
robin author 10/31/2008

open dbcommon.asp, change following sentences:

cCharset = "utf-8"

Session.LCID = 2052

session.codepage=65001
open templates folder

add <meta http-equiv="Content-Type" content="text/html; charset=utf-8"> before {BEGIN style_block} for all files


That works.

Thanks gemini.
And is others have easy way to do follows? That too much files.

---- open templates folder,add <meta http-equiv="Content-Type" content="text/html; charset=utf-8"> before {BEGIN style_block} for all files.

R
robin author 10/31/2008

I'm trying other way, that works.

  1. select Language = multilanguage (English and Chinese)
  2. Select region = chinese(PRC)
  3. modify dbcommon.asp, change

    cCharset = "utf-8"

    Session.LCID = 2052

    session.codepage=65001
    That ok.
    Remark:

    Language MUST select multilanguage, if only select Chinese, it does not work.

G
gemini 10/31/2008

I'm trying other way, that works.


  1. select Language = multilanguage (English and Chinese)
  2. Select region = chinese(PRC)
  3. modify dbcommon.asp, change

    cCharset = "utf-8"

    Session.LCID = 2052

    session.codepage=65001
    That ok.
    Remark:

    Language MUST select multilanguage, if only select Chinese, it does not work.


yes, It is easy!