you described that the database you have contained Chinese content but when you try to disaply the results from query on web page, you get '?'
it looks like encoding problem. are you using GB2312 on your web pages?
also, if user input can't be stored correctly in Access database, it could mean that the webpages are encoded in GB2312 while Access is in some other encoding format.
there are two different problemsyou described that the database you have contained Chinese content but when you try to disaply the results from query on web page, you get '?'
it looks like encoding problem. are you using GB2312 on your web pages?
also, if user input can't be stored correctly in Access database, it could mean that the webpages are encoded in GB2312 while Access is in some other encoding format.
input no problem
When I input Chinese through webpage and store in Database, it is ok. The chinese characters are displayed in database.
But when I retrieve data from database, it shows "?" on website.
input no problemWhen I input Chinese through webpage and store in Database, it is ok. The chinese characters are displayed in database.
But when I retrieve data from database, it shows "?" on website.
so, what can I do yah?
Thanx
Access should be using UTF8 format
and if you web page is using GB2312, then it can't be displayed properly.
Access should be using UTF8 formatand if you web page is using GB2312, then it can't be displayed properly.
so what can I do now? HELP!!~~~
**********************************************************************
To discribe my situation again:
I am currently designing a chinese resource repository using JSP and MS Access.
The data in Access is in Chinese.
Case 1: when I enter data in to db through website, the chinese characters can store in Access nicely in Chinese.
Case2: When I try to retrieve data from db to webpage, all the chinese charactors become "Luan Ma". Most of the "Luan Ma" are question marks "???"
I have been trying to solve this problem for 2 days, but still could not find an solution
so what can I do now? HELP!!~~~**********************************************************************
To discribe my situation again:
I am currently designing a chinese resource repository using JSP and MS Access.
The data in Access is in Chinese.
Case 1: when I enter data in to db through website, the chinese characters can store in Access nicely in Chinese.
Case2: When I try to retrieve data from db to webpage, all the chinese charactors become "Luan Ma". Most of the "Luan Ma" are question marks "???"
I have been trying to solve this problem for 2 days, but still could not find an solution
there are some reference, but I still could not get it.
http://www.itpub.net/247487.html
http://www.java-cn.com/bbs-jsp/show.jsp?id=1574&forum=chinese
http://www.weste.net/html/200405/20040521QBI075546.html
Do you have any idea how to solve the proble?
what is the default chinese Unicode in MS access? IE? JSP? Tomcat?
You can set the encoding for your web page as well as db access.