Skip to main content
Known Participant
June 1, 2010
Question

Displaying French Letters from Database in ASP

  • June 1, 2010
  • 1 reply
  • 470 views

I have a Database SQL Server 2005 which contains french words with accented letters like 'é' , 'ç' and 'â'. When I display them in my ASP pages from a recordset, it displays different characters.

Example:

Télévision displays Télévision.

I have the following meta tags in my pages.

<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />

If I look at the data in the database, it shows Télévision but not I'm my pages.

This topic has been closed for replies.

1 reply

June 2, 2010

What is the collation settings in your SQL server, database, table and fields?

I think page charset and database collation settings are different.

Try to change encoding settings in your browser to see if you can display properly on UTF-8.