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.
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.
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.
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.
None
0 Points
17 Posts
Encoding
Aug 31, 2005 05:32 PM|monitor|LINK
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
Contributor
4150 Points
5249 Posts
Re: Encoding
Aug 31, 2005 11:26 PM|Caddre|LINK
None
0 Points
2 Posts
Re: Encoding
Sep 02, 2005 03:14 PM|Rose9994You|LINK
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
http://www.freenezy.com
None
0 Points
2 Posts
Re: Encoding
Sep 05, 2005 02:54 PM|Rose9994You|LINK
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
http://www.freenezy.com
Contributor
4150 Points
5249 Posts
Re: Encoding
Sep 05, 2005 04:16 PM|Caddre|LINK