Displaying French Letters from Database in ASP

[Brachole]

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.

[Guest]

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.