By sunion on

For some reason the 'Global: Combine fields filter' is case INsensitive on my local development pc, and when I upload it on my server, it is case sensitive. Is there a way to force it to be case INsensitive?

⋅ Categories: Drupal 7.x

Comments

alextataurov’s picture

alextataurov commented

I think it depends on your mysql preferences for string comparison. Check this thread http://drupal.org/node/1805272

In order to make the search case insensitive you could change the collation for your table fields.

sunion’s picture

sunion commented

Both databases use utf8_general_ci.

sunion’s picture

sunion commented

It seems that it is only case sensitive if one of the fields is of type integer and not a string.
How can I search for a string 'case insensitive', or an integer?