Defect #28807

Cannot search in a case-insensitive manner

Added by Stefan Kuhr over 4 years ago. Updated over 4 years ago.

Status:NewStart date:
Priority:NormalDue date:
Assignee:-% Done:


Target version:-
Resolution: Affected version:


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


#1 Updated by Jens Krämer over 4 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. may be helpful with figuring out what's going on.

Also available in: Atom PDF