Bug #64598 Query result not exactly with LIKE keyword and unicode character.
Submitted: 9 Mar 2012 3:41 Modified: 9 Apr 2012 8:55
Reporter: Nguyen Hieu Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Server: Windows Severity:S3 (Non-critical)
Version: OS:Any
Assigned to: CPU Architecture:Any

[9 Mar 2012 3:41] Nguyen Hieu 
Description:
Query result not exactly with LIKE keyword and unicode character.

How to repeat:
Run a query with LIKE keyword, example: 

"SELECT FullName FROM Employees WHERE FullName LIKE '%o%'"

The result return all FullName content 'o', 'ô', 'ơ', 'ó', 'ò', 'ọ', 'ố', 'ồ', 'ộ', 'ờ', 'ớ', 'ợ'
[9 Mar 2012 8:38] Peter Laursen 
This is same discussion as yesterday here: http://bugs.mysql.com/bug.php?id=64578

It depends on what COLLATION you use.  You can add an explicit COLLATE clause to the query.

Peter
(not a MySQL person)
[10 Apr 2012 1:00] Bugs System 
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".