Error on Display Chinese Character that extract from MS SQL2005 database

I want to ask is that your SQL2005 Database do not support chinese character data? I successfully insert chinese character into database but can't display data correctly when select the data from the database. Is that I miss any setting in the database?

Anyone could help? Thanks.

 

I think the problem is not with the SQL 2005 database, as it should be able to store Chinese characters fine. Are you having trouble selecting the data or displaying the data in a browser?

Make sure that you are using double-byte data types, like nvarchar or ntext. What does your select query look like?

DiscountASP.NET
www.DiscountASP.NET

 

Yes, I can't view the character correctly in the browser. In the database table, I use nvarchar(MAX) to store the field already.

My SQL select string like the following

strSQL = "select itemno, name, category, scurrency, price, picture, description from product order by createdate desc"

All the chinese character display as ???

Thanks.

 

I try to add the following code under web.config, but still unable to show chinese character in browser

<system.web>
<globalization
fileEncoding="UTF-8"
requestEncoding="UTF-8"
responseEncoding="UTF-8"
culture="en-US"
uiCulture="zh-CHT"
/>
</system.web>

I hope anyone could help. It's urgent for my website publish.

Thanks much.
Mr. Patrick Yip

 

try changing UTF-8 to UTF-16


Joel Thoms

DiscountASP.NET
http://www.DiscountASP.NET

 

Itry to change to UTF-16, but still the same.


Please visit http://www.seehungsys.com/product.aspxfor the actual output.
I dont' know what should I do. Do you have any sample page that shows hosting under your company's server could display chinese character correctly? I don't know what can I do right now.

Hope anyone could give hand. Thanks.

Thanks,
Patrick

 

The page encoding looks right. By browser is switching to UTF-8. This could only mean that the data stored in your database is not Chinese. Do you see the Chinese characters when opening the table with SQL Management Studio?

DiscountASP.NET
www.DiscountASP.NET

 

Dear Support Team,


How could I open the table and view the datawith SQL Management Studio? I don't know how could I view it. Thanks.


In addition, could you please help me to check the table with the name "product" whether the name and description field contains chinese character? I have successfully insert record to this table but can't display the chinese character that I entered. Thanks.


Patrick