Re: Cannot display Chinese data from database
- From: "Joerg Jooss" <news-reply@xxxxxxxxxxxxx>
- Date: Fri, 25 Nov 2005 10:40:24 -0800
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 responseEncoding in web.config to Big5
> - hardcoded Response.ContentEncoding 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(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
> }
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:news-reply@xxxxxxxxxxxxx
.
- Prev by Date: Re: Netscape caching my asp.net pages...
- Next by Date: Re: Drag drop in web forms
- Previous by thread: ASP.NET does not honor Title nor Javscript options
- Next by thread: Odd behavior in 2005 with base page classes
- Index(es):
Relevant Pages
|
