Defect #28807

Cannot search in a case-insensitive manner

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

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

0%

Category:-
Target version:-
Resolution: Affected version:

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

History

#1 Updated by Jens Krämer over 3 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.

Also available in: Atom PDF