I am retrieving nvarchar values from an sql2005 database that contain chinese characters.
Firstly, I am storing chinese characters as nvarchar data type. I am able to save the data as chinese characters but when I view the table on MSSQL 2005 I cannot see chinese characters. But if I clipboard the field it will paste as chinese characters so I am pretty sure the database preserves them somehow.
But when I retrieve the value into a textbox or a label on a webform it will always display as ???????? (literally).