Chinese Characters - ASP, SQL, XSL

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?
LVL 10
slamhoundAsked:
Who is Participating?
 
kelvinwkwConnect With a Mentor Commented:
Found one convertor here
http://www.macchiato.com/unicode/convert.html

Right click view source,
copy the javascript...
hopefully this help.
0
 
kevp75Commented:
you will have to change the code page....
i believe this may help
0
 
kelvinwkwCommented:
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
0
Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 
slamhoundAuthor Commented:
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.
0
 
kelvinwkwCommented:
http://www.blueshop.com.tw/board/show.asp?subcde=BRD20060518222103RFP&fumcde=

Try the convertor then

from big5 or GB2312 to utf-8

Regards
Kelvin
0
 
slamhoundAuthor Commented:
This looks good (although I can't read the Chinese text) but I'm not sure how to implement it. When and why do I do this conversion?
0
 
kelvinwkwCommented:
Sorry i tot u read chinese =)
wat a stupid assumption haha

Do it during the insertion or updating to the db

Regards
Kelvin
0
 
slamhoundAuthor Commented:
Yeah, I'm Australian but the client has a Hong Kong distributor. Makes it much harder knowing only one of the languages. :)

Which section of code should I use (I can't tell because of the Chinese comments) and do I do the reverse when reading it out again?

0
 
nurbekConnect With a Mentor Commented:
try to force to use utf when inserting/reading data from db

<%@LANGUAGE="VBSCRIPT" CODEPAGE="65001"%>

<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
0
 
kevp75Connect With a Mentor Commented:
sorry about that, I fogot to post the link...
http://www.science.co.il/Language/Locale-Codes.asp?s=hexadecimal
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.