Some chinese characters data (in Big5 encoding) is stored in database.
I tried to display the data in an aspx but the characters cannot display
correctly.
I tried anything I think is related:
- Setting the charset, codepage of the page
- changed the responseEncoding in web.config to Big5
- hardcoded Response.ContentEncoding to 950 (codepage of Big5)
- Change the file encoding to Big5 (in save option)
None of them work.

For the same data, it can displayed correctly in my classic asp.

Code (.NET)
private void Page_Load(object sender, System.EventArgs e)
{
    SqlConnection connection = new
SqlConnection(ConfigurationSettings.AppSettings["NewsDB"]);
    SqlCommand command = new SqlCommand();
    command.Connection = connection;
    command.CommandText = "SELECT Newsid, StoryDate, StoryTime, Headline
FROM tblLatestHeader";
    command.CommandType = CommandType.Text;

    SqlDataReader dataReader;
    connection.Open();
    dataReader = command.ExecuteReader();
    string html = "";
    while (dataReader.Read())
    {
        html += dataReader[3].ToString();
    }
    connection.Close();
    Label1.Text = html;
    Label2.Text = "你好嗎";  // this is chinese character which can display
correctly
}


Work in classic asp:
<%
Set connection = Server.CreateObject("ADODB.Connection")
connection.ConnectionString = "Provider=sqloledb;Data Source=MyDB;Initial
Catalog=NewsDB;User Id=sa;Password=fakepwd;"
connection.open
Set rs = connection.execute("SELECT Newsid, StoryDate, StoryTime, Headline
FROM tblLatestHeader")

While Not rs.eof
    rs.movenext
wend
%>

Jason Chan wrote:

The Codepage directive in ASP.NET 2.0 is the same as reponseEncoding in
web.config.

And these are identical as well (the latter, like Codepage, works at
the page level though).

That's only relevant at buildtime.

Show quoteHide quoteIf your hardcoded sample text is displayed correctly, there's quite
likely a problem with your ADO.NET provider. Are the correct characters
displayed when you debug your code right after retrieving strings from
the database?

Cheers,

How to add a small HTML table under a row of a GridView
Visual Web Developer Express How do I build Code-behind into DLL in bin folder
Application["TotalPlayings"]++ doesn't work
Source Control Products???
Downloading file from database
ASP classic -> ASP.NET 2.0
A translatable website
Problem Running ASP.NET/ASP App Under VS 2005
Cannot POST to .XML page
specifying a query string in an href dynamically