Issue Bug Closed

#24774Search with LIKE is case sensitive on Oracle

Xavier Perseguers 01/24/11, 15:33 updated 01/31/11, 16:07

Description

On Oracle, when performing a LIKE query, the statement is rewritten with dbms_lob.instr() function. However this statement is case sensitive whereas LIKE under MySQL is (normally) case insensitive.

As such, behavior of search is not the same as when using MySQL.

Solution: convert content to lower case with LOWER on column name and t3lib_div::strtolower() on argument.

Downside: any index on the column should be aware of this and be provided as an index on LOWER content. However as most LIKE statements are using %-pattern on both sides of the argument, an index cannot be used anyway.
(issue imported from #M17269)

Reviews 0

No change resolves or names this issue in its commit message, and no comment links one.