Currently we have Norwegian and English(UK) customers. We are going international and need support for all languages. What is the best way to do this? I am currently doing testing with Chinese.
I have tried using UTF-8 in asp and html. Chinese characters are displayed, but when I try to update the database the characters are converted to ???. If i save directly in enterprise manager, it works.
According to: http://seba.studentenweb.org/thesis/db-sql.php
Unicode values must have N in front of the string. I.e UPDATE Table SET Field = N'value';
That means we have to change ALL sql queries in our application. That's a lot of changes! There must be some other way.
Using N works though!
But according to: http://www.sql-server-performance.com/datatypes.asp
Using N resuls in poor performance.
What are my alternatives, what is the best thing to do?
1. Use N.
2. Set up new server for each new language. Do I still have to use N for chinese characters?
I know that when using Norwegian/Danish collation on SQL server (as we do) then the index will not be correct if a user inserts chinese characters. That, with the point of using N results in poor performance, suggest one server for each language.
I really can't believe it is this hard to support different languages. To have one server for each language and use N in SQL queries seems ridicolous.
According to: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/html/sql_dataencoding.asp
When web-application and database both use Unicode, then conversion should be handled automatically. This is the case for us, but why isn't it working? Could it be because I have a norwegian keyboard and all characters have been copied/pasted from chinese sites.
Database: Microsoft SQL Server 2000. Set up with Norwegian/Danish collation.
Fields: All text fields are using unicode - nchar/nvarchar/ntext
Application: ASP/VbScript/COM with 65001 codepage and UTF-8 charset
HTML: UTF-8 charset
Response.CodePage = 65001
session.CodePage = 65001
Response.CharSet = "utf-8"
<meta http-equiv="Content-Type" content="text/html;charset