Encoding

Question

User97728421 posted
I work on multilingual appliction that displays data in English & French.
English part works as expected.
French is displayed incorectly
catégorie becomes catégorie
i'm puling this information from database.
Does anybody has an idea how to fix this.
Also i do have this meta tag in the header:
<META http-equiv="Content-Type" content="text/html; charset=utf-8" >
Thanks

Answer 1

User1416329745 posted
In SQL Server you enable Unicode encoding by using NChar, NVarchar and NText datatypes and you can do column level collation.  Unicode in SQL Server is multibytes so NChar is 4000, NVarchar is 4000 and  NText is 1gig.  Run a search for Unicode collation in SQL Server BOL (books online).  Hope this helps.

Answer 2

User-571966013 posted
If  your Problem is not solved as Db solution provided in earlier post then

Try This
Delete Meta Tag
I forget full code but it is like Response.header or charset set it to UTF-8

Then it work fine

I have done this but i forget original code Search in MSDN 
This will work definetly because I faced this problem if ur page is dyanamic ie asp,asp.net , php etc it must be seted through server side
meta tag only work when file static i.e.  .htm , .html etc.

Also Don't Use both  meta + Server tag

Hope ur Problem solved

Answer 3

User-571966013 posted
Here Is response.charset Document from MSDN

Charset
The Charset property appends the name of the character set (for example, ISO-LATIN-7) to the content-type header in the response object.

Syntax
Response.Charset(CharsetName)


Parameters
CharsetName

A string that specifies a character set for the page. The character set name will be appended to the content-type header in the Response object.

Example
For an ASP page that did not include the Response.Charset property, the content-type header would be

content-type:text/html

If the same .asp file included

<% Response.Charset= "ISO-LATIN-7" %>

the content-type header would be

content-type:text/html; charset=ISO-LATIN-7
 
Remarks
This function inserts any string in the header, regardless of whether it represents a valid character set or not.

If a single page contains multiple tags containing Response.Charset, each Response.Charset will replace the previous CharsetName. As a result, the character set will be set to the value specified by the last instance of Response.Charset in the page.

On Macintosh computers, the default U.S. character set is not ISO-LATIN-1. When serving up documents, Personal Web Server for Macintosh automatically converts from the Macintosh character set to ISO-Latin-1. In the U.S. version, all pages are assumed to be in the U.S. Macintosh character set unless the Response.Charset is used. If Response.Charset is used to change the character set, Personal Web Server for Macintosh does not convert the character set.

Applies To
Response Object

Answer 4

User1416329745 posted
What the person is getting is called character conversion based on SQL Server data which is usually fixed with SQL Server 2000 column level language collation.  I have solved similar problem for someone on another site with the column level collation.  Hope this helps.