I am storing English, Czech, Turkish and Chinese within the same SQL 2008 Database - field using nvarchar (Latin 1) Depending on where the visitor is from the web page charset is set to iso-8859-1 or utf-8 etc. I am using Classic ASP(also have tried it in
ASP.NET) the Response.CodePage is set to 1252. When the data is queried the correct characters are shown on the web page but when saved to text or excel file they are corrupted. Do I have the database correctly set-up to use multiple language in a field.