Defect #28807
open
Cannot search in a case-insensitive manner
0%
Description
Hello everyone,
we have just upgraded from Redmine 2.5.1.stable to 3.2.1.stable (installed on a newly installed Ubuntu 16.04LTS). Now we cannot search anymore in a case insensitive way. E.g. we get a different result when searching for "abb" than for "ABB", so nothing fancy here such as Umlauts or non-ASCII characters that we are searching for, just plain 7-bit ASCII search terms yield different results when cased differently.
We use the following versions:
Redmine version 3.2.1.stable
Ruby version 2.3.1-p112 (2016-04-26) [x86_64-linux-gnu]
Rails version 4.2.10
Environment production
Database adapter Mysql2
Is this a problem with ruby being version 2.3.1 (the installation guide only lists versions 1.9.3, 2.0.0, 2.1 and 2.2 as being supported for redmine 3.2)?
We just did a default install of the required packages as they come with Ubuntu 16.04LTS. What are we doing wrong?
Best regards,
--
Stefan Kuhr
Updated by Jens Krämer over 6 years ago
I just checked with latest stable (3.4). Redmine uses simple LIKE queries which are assumed to be case insensitive (i.e. it does not explicitly downcase query tokens but does LIKE '%ABB%'). This works fine with MySQL and PostgreSQL in any scenario I have seen so far.
However it may be that the character set settings in your mysql db are somehow turning LIKE into being case sensitive. The docs (i.e. https://dev.mysql.com/doc/refman/8.0/en/case-sensitivity.html) may be helpful with figuring out what's going on.