Support » Plugin: Participants Database » Case (in)sensitive search

  • Resolved eljailer

    (@eljailer)


    Hello Roland!
    Thank you again for this awesome plugin, I’ve been using it for quite some time and it works great 🙂

    I have an issue, though: strict search seems to be ON all the time. By that I mean case sensitive search. I tried turning it on and off in the Advanced settings section, but it works only if I input ‘John’ while ‘john’ query returns ‘no records found’.

    Any help or advice would be greatly appriciated.

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Author xnau webdesign

    (@xnau)

    Database searches are normally case-insensitive, but this can be changed by using a different collation setting on your database. If you don’t know what that is, you should probably contact your web host. The default collation setting for an English-based database is usually ‘latin1’ or ‘latin1_swedish_ci’ which will give you case-insensitive searches.

    eljailer

    (@eljailer)

    Thank you so much for your response!!!
    Yes, changing the collation solved the problem.
    Thank you again!

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Case (in)sensitive search’ is closed to new replies.