Bug #26105 Bug with Internet Explorer and Thai character( and PHP).
Submitted: 6 Feb 2007 7:04 Modified: 6 Feb 2007 9:11
Reporter: Anton Will Email Updates:
Status: Not a Bug Impact on me:
Category:MySQL Server Severity:S3 (Non-critical)
Version:4.1 OS:Windows (Windows XP)
Assigned to: CPU Architecture:Any
Tags: Internet Explorer, query, Thai

[6 Feb 2007 7:04] Anton Will
I create a form and use GET variables to pass a value in my AJAX website.
I don't have any problem until I pass Thai character to php file that use
those Thai character in a query and then create xml data.

Request example:


This test.xml.php use values in 'username' and 'stat' to do query which work
well in Mozilla Firefox. But there are error with Internet Explorer.

Error report:
  WHERE username='

It's look like MySQL query doesn't know this Thai character and misinterpret them.

How to repeat:
Create a table

   username  |    stat
       พิภพ     |    active
       นภา      |   inactive

Then try to query this table with Thai words which sent by GET variable(PHP)
in Internet Explorer.
[6 Feb 2007 9:11] Sveta Smirnova
Thank you for taking the time to write to us, but this is not a bug. Please double-check the documentation available at http://dev.mysql.com/doc/ and the instructions on
how to report a bug at http://bugs.mysql.com/how-to-report.php

MySQL server itself can not separate different data sent from Firefox or Internet Explorer. It only uses data passed to it by your PHP application. So it is surely not our bug.