Re: Arabic IIS6 Windows 2003 Issue

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: David Wang [Msft] (someone_at_online.microsoft.com)
Date: 02/27/05


Date: Sun, 27 Feb 2005 05:19:01 -0800

Please do not multi-post to several newsgroups.

Usually, it is the responsibility of the application to ensure that data is
encoded correctly between the browser and database.

I believe that IIS6 is able to correctly handle your scenario, assuming the
web application correctly read the encoded data. We have tests that are
able to submit characters from multiple languages SIMULTANEOUSLY (including
Arabic, Hebrew, Japanese, German, Chinese (Traditional), Chinese
(Simplified), etc ) on a form to IIS6, have it saved correctly to SQL, read
from SQL, and reflected back to the client -- and we do this when IIS is
running on different OS languages -- so I believe that IIS6 should be more
than able to handle your scenario.

English characters tend to work because most character sets keep them at
identical index -- so it can accidentally "work" even though you do not have
character encodings configured correctly at all.

My question is more concerned with how your application ensures that data is
correctly encoded between the browser, server, and into the SQL database,
because any misconfiguration will lead to questionmarks/unknown characters.
Can you describe how you configured all this for IIS5 and IIS6?

Key information:
OS System Locale/Language for client and server
Browser Language configuration.
UTF8 allowed by browser
Response/Request encoding specified by the web page platform
etc...

-- 
//David
IIS
http://blogs.msdn.com/David.Wang
This posting is provided "AS IS" with no warranties, and confers no rights.
//
"Rany M. Sabry" <ranysabry75@hotmail.com> wrote in message
news:uZaB0LBHFHA.1396@TK2MSFTNGP10.phx.gbl...
I 'm having a web pages working probably in IIS5 (Windows2000), the web
pages has a form submitting an Arabic characters into SQL database.
When doing so using IIS5 (Windows2000) it works fine, and when doing so
using IIS6 (Windows2003) it gives marks and unknown characters, however,
when i submit an English characters it works fine with me.
Actually my team did the best trying to solve this problem so does anyone
knows whets the wrong with system or the environment.
-- 
Yours,
Rany M. Sabry
----------------------
IT Specialist
Head of Technical Administration Team
The Egyptian Cabinet - Information & Decision Support Center (IDSC) -
National Information Sector (NIS)
1 Magless Elshaab St. - Cairo - Egypt
Tel: +202 7929292 ext. 533    -  Direct +202 3668533
rzaher@idsc.net.eg
http://www.idsc.gov.eg


Relevant Pages

  • Re: cant insert cyrillic or greek charachters into mssql db
    ... incorrect characters. ... You use mssql - it ... Showing the Characters in the Browser is no problem, ... data should be insertet into an MS SQL Database (The datatype of the ...
    (comp.lang.php)
  • Re: Unicode support
    ... I see characters in &#dddd; ... Is it okay to see characters in this format in database? ... Somewhere on the way Unicode characters are encoded to HTML entities. ... browser the right encoding. ...
    (comp.lang.java.programmer)
  • Re: Loading a data file containing character fields with different encodings
    ... The data is coming from one database that contains UTF-8 characters and it appears that he's attempting to load ... UTF-8 characters along with Latin-1 characters. ... it would be just as easy to write the loader script that converts the encoding to a "unicode" intermediate format and then load with the correct database encoding. ...
    (comp.databases.informix)
  • Re: Loading a data file containing character fields with different encodings
    ... The data is coming from one database that contains UTF-8 characters and it appears that he's attempting to load ... UTF-8 characters along with Latin-1 characters. ... it would be just as easy to write the loader script that converts the encoding to a "unicode" intermediate format and then load with the correct database encoding. ...
    (comp.databases.informix)
  • Re: Size matters to some
    ... BobJ wrote: ... specified to the DBMS tools with a maxlen specification, ... database does, without the maxlen specification to the DBMS. ... Field A is supposed to be 2 characters of a country abbreviation, ...
    (comp.databases.pick)