Actions
Bug #24774
closed
Search with LIKE is case sensitive on Oracle
Start date:
2011-01-24
Due date:
% Done:
0%
Estimated time:
TYPO3 Version:
PHP Version:
Tags:
Complexity:
Is Regression:
Sprint Focus:
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)
Files
Updated by Xavier Perseguers almost 14 years ago
Adapted unit tests and committed to trunk as rev. 42537.
Actions