we have a ASP portal running under IIS6. The databases behind runs on SQL Server. We've had the problem both on SQL Server 2008 and SQL Server 2000.
All of a sudden the portal started returning weird characters in place of French accented letters. For Example: "Jérôme" is now shown as "JÃ©rÃ´me".
The problem can be easily fixed by adding this line at the top of the asp page:
<meta HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=UTF-8">
But we don't want to modify all pages in the website.
If I execute the query directly on SQL Server console the name is shown correctly.
We haven't changed the collation of the database.
Why is this happening all of a sudden?
How can I fix it?
OS: Windows Server 2003 SP2
Web server: IIS 6
Database Server: SQL Server 2000
The server is up to date.
IIS and SQL Server reside on the same server.