My website connect to MS SQL Server 2005 and all the chinese data are
displayed as ????.
I try to fix the problem for several days, but still can't fix it. Please
help me to solve this problem.
here is the detail of my system.
* SQL Server 2005 via TCP/IP
* the connection string is "Provider=SQLOLEDB.1;Persist Security
Info=False;User ID=xx;Initial Catalog=websonic_pos;Data
Source=xx.xx.xx.xx;Password=xx;"
You should ensure that you use the correct Code Page in your web.config file.
And then you should ensure that your data in your SQL Server database is
correct
and shows Chineese characters in the right way. After ensuring this, you can
assume that you use an incorrect Code Page in your web configuration file !
This problem occurs usually because of the wrong code page setting.
Ekrem Önsoy