I have a ASP site that uses XSL and a SQL 2000 backend to take orders for labels. Head office uses an Access front end to manage/print the labels. The client wants customers to be able to put Chinese characters on their labels.
Currently the website saves a lot of '???' instead of the characters but the characters are fine if you enter them directly into SQL using Enterprise Manager. I'm currently using UTF-8 character set and unicode fonts so that the site handles French special characters.
How do I set things up to accept Chinese characters?
Do I need a Chinese SQL server?
Do I need a Chinese web server?
Where can I look to make this work?
Any ideas, suggestions or hints?
This Question has been solved and asker verified All Experts Exchange premium technology solutions are available to subscription members.
Experts Exchange has been collecting answers to technology questions since 1996…3 million and counting! If you have a question, chances are we already have your answer.
If you can't find the exact answer you're looking for, ask our exclusive community of 50,000 experts. You’ll get a personalized answer from a trusted professional.
Thousands of free tech tips, tricks, how-to’s and tutorials are available in our peer reviewed articles section. See for yourself how smart our experts are, no login required.
Save solutions to your questions, answers you’ve discovered through searching plus helpful articles in your personal knowledgebase for easy future access.
Access the answers to your technology questions today.
30-day free trial. Register in 60 seconds.
Members of the expert community talk about why the experience at Experts Exchange is different than what you will find anywhere else.
Try it out and discover for yourself.
30-day free trial. Register in 60 seconds.
Join the community of experts here and help other tech pros by answering question in your area of expertise. You can earn FREE access to all Experts Exchange's premium features and resources.
well you should get an utf-8 chinese inputer to key in the data
for instance NJStar Communicator 2.60 at www.njstar.com
and add this at all the page
To display Traditional Chinese
<meta http-equiv="Content-Type" content="text/html; charset=big5" />
To display Simplified Chinese
<meta http-equiv="Content-Type" content="text/html; charset=gb2312"/>
To display Under UTF-8
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
Regards
Kelvin
I am currently using the UTF-8 character set on all pages so they can handle French speical characters. You can enter Chinese characters into fields and this will stay in the shopping cart so the summary displays correctly. But when the order is saved to the DB, it just saves questionmarks. Entering the characters directly into SQL or Access linked to SQL works fine.
http://www.blueshop.com.tw
Try the convertor then
from big5 or GB2312 to utf-8
Regards
Kelvin
sorry about that, I fogot to post the link...
http://www.science.co.il/L
Found one convertor here
http://www.macchiato.com/u
Right click view source,
copy the javascript...
hopefully this help.
Business Accounts
Answer for Membership
by: kevp75Posted on 2006-05-23 at 18:10:42ID: 16747773
you will have to change the code page....
i believe this may help