Bug #56042

Case sensitive search

Added by Tanel Põld almost 6 years ago. Updated about 5 years ago.

Should have
Target version:
Start date:
Due date:
% Done:



Page structure and link search seem to be case sensitive.
Match case could be optional.


#1 Updated by Christian Müller over 5 years ago

Just had a look at that and it's pretty difficult right now. Properties are stored as BLOB (that means binary for the DB). Being binary again means that LIKE queries will be case sensitive. Using a LOWER expression on the properties field and the search term isn't enough as MySQL at least would require you to CONVERT the text prior to lowercasing (and then the lowercasing is unnecessary). But CONVERT is not a function offered by Doctrine (LOWER is) so this is not an option. Changing the field type of the properties field from BLOB to TEXT works quite well in combination with LOWER, but that again is against Doctrines "objectarray" type. We still could do this to allow this kind of queries.

#2 Updated by Markus Goldbeck about 5 years ago

  • Assignee set to Markus Goldbeck

#3 Updated by Markus Goldbeck about 5 years ago

  • Status changed from New to Closed

Also available in: Atom PDF