Cannot display Chinese data from database

[Jason Chan]

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 responseEncodin g in web.config to Big5
- hardcoded Response.Conten tEncoding 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(objec t sender, System.EventArg s e)
{
SqlConnection connection = new
SqlConnection(C onfigurationSet tings.AppSettin gs["NewsDB"]);
SqlCommand command = new SqlCommand();
command.Connect ion = connection;
command.Command Text = "SELECT Newsid, StoryDate, StoryTime, Headline
FROM tblLatestHeader ";
command.Command Type = CommandType.Tex t;

SqlDataReader dataReader;
connection.Open ();
dataReader = command.Execute Reader();
string html = "";
while (dataReader.Rea d())
{
html += dataReader[3].ToString();
}
connection.Clos e();
Label1.Text = html;
Label2.Text = "ä½*好嗎" ; // this is chinese character which can display
correctly
}
Work in classic asp:
<%
Set connection = Server.CreateOb ject("ADODB.Con nection")
connection.Conn ectionString = "Provider=sqlol edb;Data Source=MyDB;Ini tial
Catalog=NewsDB; User Id=sa;Password= fakepwd;"
connection.open
Set rs = connection.exec ute("SELECT Newsid, StoryDate, StoryTime, Headline
FROM tblLatestHeader ")

While Not rs.eof
response.write rs("Headline") & "<br>"
rs.movenext
wend
%>

[Joerg Jooss]

Jason Chan wrote:

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
The Codepage directive in ASP.NET 2.0 is the same as reponseEncoding in
web.config.
- changed the responseEncodin g in web.config to Big5
- hardcoded Response.Conten tEncoding to 950 (codepage of Big5)
And these are identical as well (the latter, like Codepage, works at
the page level though).
- Change the file encoding to Big5 (in save option)
That's only relevant at buildtime.
None of them work.

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

Code (.NET)
private void Page_Load(objec t sender, System.EventArg s e)
{
SqlConnection connection = new
SqlConnection(C onfigurationSet tings.AppSettin gs["NewsDB"]);
SqlCommand command = new SqlCommand();
command.Connect ion = connection;
command.Command Text = "SELECT Newsid, StoryDate, StoryTime,
Headline FROM tblLatestHeader ";
command.Command Type = CommandType.Tex t;

SqlDataReader dataReader;
connection.Open ();
dataReader = command.Execute Reader();
string html = "";
while (dataReader.Rea d())
{
html += dataReader[3].ToString();
}
connection.Clos e();
Label1.Text = html;
Label2.Text = "ä½*好嗎" ; // this is chinese character which
can display correctly
}

If 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,
--
http://www.joergjooss.de
mailto:ne****** **@joergjooss.d e