How to disable case sensitive search in Versjon 7.7.5

💬 General Discussion
1

How to disable case sensitive search in Versjon 7.7.5 ??
Cant find a meeting with f.ex this subject :

Search for Sortland: No result

Looking for this meeting:
JJ/5098591 Coop Prix Sortland 25.11.16 1100

Is it possible to adjust search sensitivity?

2

Try %Sortland in the search bar

3

yeah, that worked.
How to add % to be default in i search string ?

4

yup.

Add this line to your config_override.php file

$GLOBALS['sugar_config']['search_wildcard_infront'] = true;
1 Like
5

this just add a % wildcard at begin, but will this disable the case sensitive search in flavour of case insensitive?

6

Did you test it?

It has the effect of adding a “%” character at the beginning of the LIKE clause that goes into your database.

Depending on which database type (MySQL, MSSQL, etc), and the specific database collations and even specific column collations, this might bring different results. But my guess is that it will be case-sensitive.