Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 381
  • Last Modified:

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.
0
alain001
Asked:
alain001
1 Solution
 
Eugene ZCommented:
check  in what datatype you store data:
use NVARCHAR NTEXT that can preserve UNICODE language characters
0

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now