Bug #10225 Like is not case-insensitive as per the documentation

• Submitted: 28 Apr 2005 5:53
• Modified: 28 Apr 2005 6:32
• Reporter: Todd Deshane
• Status: Can't repeat
• Category: MySQL Server
• Severity: S2 (Serious)
• Version: 4.1.10
• OS: Linux (Linux and Windows)
• CPU Architecture: Any

[28 Apr 2005 5:53] Todd Deshane

Description:
A.5.1 Case Sensitivity in Searches
states: 

" By default, MySQL searches are not case sensitive"

We tried the query:

 SELECT * from tableName WHERE something LIKE '%T%'

With a value of 'title' for example in the something field

then trying:

 SELECT * from tableName WHERE something LIKE '%t%'

returns the rows that have 'title' in them

We also tried changing the LIKE to 'T%'

and still no results.

How to repeat:
search for a field in the wrong case...
search for a field in the right case...
BOTH using LIKE

Suggested fix:
should be case-insensitive.  It is not czech or BINARY.

[28 Apr 2005 6:32] Hartmut Holzgraefe

Not enough information was provided for us to be able
to handle this bug. Please re-read the instructions at
http://bugs.mysql.com/how-to-report.php

If you can provide more information, feel free to add it
to this bug and change the status back to 'Open'.

Thank you for your interest in MySQL.

Additional info:

Please add a reproducable test case script