#24774Search with LIKE is case sensitive on Oracle
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.