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?