ANSI characters et translated into unicode by IIS against my will

Hello,
I am trying to re-host an ASP website from http://dreamdiscount.fr to my Windows Server 2003 with IIS 6 and SQL Server 2005 (exact same linguistic versions as the initial hosters) and it fails to produce correctly the accents and euro signs. After some analysis it seems that although everything is supposed to go through as ANSI Occidental characters, some get converted somewhere in the process into unicode characters. Thanks so much for your help.
alain001Asked:
Who is Participating?
 
Eugene ZCommented:
check  in what datatype you store data:
use NVARCHAR NTEXT that can preserve UNICODE language characters
0
All Courses

From novice to tech pro — start learning today.