Solved

ANSI characters et translated into unicode by IIS against my will

Posted on 2009-04-05
3
366 Views
Last Modified: 2012-05-06
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
Comment
Question by:alain001
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 43

Expert Comment

by:Eugene Z
ID: 24087966
check  in what datatype you store data:
use NVARCHAR NTEXT that can preserve UNICODE language characters
0
 

Accepted Solution

by:
alain001 earned 0 total points
ID: 24291247
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction: When running hybrid database environments, you often need to query some data from a remote db of any type, while being connected to your MS SQL Server database. Problems start when you try to combine that with some "user input" pass…
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
Michael from AdRem Software outlines event notifications and Automatic Corrective Actions in network monitoring. Automatic Corrective Actions are scripts, which can automatically run upon discovery of a certain undesirable condition in your network.…
Sometimes it takes a new vantage point, apart from our everyday security practices, to truly see our Active Directory (AD) vulnerabilities. We get used to implementing the same techniques and checking the same areas for a breach. This pattern can re…

623 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question