Project

General

Profile

Actions
Copy link

Bug #24774

closed

Search with LIKE is case sensitive on Oracle

Added by Xavier Perseguers almost 14 years ago. Updated almost 14 years ago.

Status:
Closed
Priority:
Should have
Assignee:
Xavier Perseguers
Category:
-
Target version:
-
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

17269.diff (1006 Bytes) 17269.diff Administrator Admin, 2011-01-24 15:42
Actions
Copy link

Also available in: Atom PDF