MySQL Bugs: #26105: Bug with Internet Explorer and Thai character( and PHP).

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:	None
Category:	MySQL Server	Severity:	S3 (Non-critical)
Version:	4.1	OS:	Windows (Windows XP)
Assigned to:		CPU Architecture:	Any
Tags:	Internet Explorer, query, Thai

Description:
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:

http://localhost/test.xml.php?username=พิภพ&stat=active

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.

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.