Chinese Characters

May 10, 2012 at 7:10 PM

I am new to ASP.Net (C#) and have spent all day trying to View Chinese characters within a Excel File created using EPPlus.

To cut my story short,  I am storing data in a database using form in Classic ASP.  The content Type is either iso-8859-1 or utf-8 (codepage 1252).  The database fields are of NVarchar type (Latin 1)

Unfortuanatly I am unable to retain the same characters the user entered on the form within the Excel file.  I can view them on the HTML page.

I have tried many different methods of converting the data (System.Text.Encoding, System.Web.HttpUtility.UrlDecode ect).  All of which does not resolve the issue.

Does anyone know to do this

Thanks