alain001
asked on
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.
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
use NVARCHAR NTEXT that can preserve UNICODE language characters