I am storing Chinese and English text in an SQL Server 2005 database and displaying it on a webpage, but the Chinese is not being displayed correctly.
I have been reading about the subject and have done the following:
- used N before the text in my INSERT statement
- set the field type to nvarchar
- set the charset of the page to UTF-8
Chinese characters are being displayed in the page correctly when I insert them directly into the page i.e. don't get them from the database
These are the characters that should be displayed:全澳甲流确诊病例已破100
This is what is displayed when the text is retrieved from the database: å…¨æ¾³ç”²æµç¡®è¯Šç—…ä¾‹å·²ç ´1001
This seems to be something that is related to how strings are handled in c# because the Chinese can get retrieved and displayed correctly in classic asp
Is there anything else I need to do to get the data out of the database, into a string and output correctly on an aspx page?