Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 450
  • Last Modified:

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?
0
slamhound
Asked:
slamhound
  • 4
  • 3
  • 2
  • +1
3 Solutions
 
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
 
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
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
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
 
nurbekCommented:
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
 
kevp75Commented:
sorry about that, I fogot to post the link...
http://www.science.co.il/Language/Locale-Codes.asp?s=hexadecimal
0
 
kelvinwkwCommented:
Found one convertor here
http://www.macchiato.com/unicode/convert.html

Right click view source,
copy the javascript...
hopefully this help.
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 4
  • 3
  • 2
  • +1
Tackle projects and never again get stuck behind a technical roadblock.
Join Now