Search with special characters

  • Resolved marnyscom

    (@marnyscom)


    3 years, 3 months ago

    Hi,
    We are facing an issue when we search in spanish with our special characters.
    For example, when we search ‘colageno’ we don’t get the results of ‘colágeno’.
    Is there a way to fix this? We have a lot of words with accent mark.
    Thank you.

Viewing 1 replies (of 1 total)
  • Plugin Author Damian Góra

    (@damian-gora)

    Hi,
    I guess it’s related to collations of your tables posts and postmeta in your MySQL. It is not something you can set in FiboSearch settings. It’s a general feature of your WordPress installation.

    First, check what the collation of these tables is. You can do it via phpMyAdmin or similar tools. If it is utf8mb4_spanish_ci or similar, accent marks will not be ignored and colágeno and colageno will be compared as different words.

    Words colágeno and colageno will be compared as the same word for default WordPress collation – utf8mb4_unicode_520_ci or utf8_general_ci.

    Changing the collation of your WordPress tables is a risky task. If you aren’t familiar with MySQL, you should ask the person who created your website and changed the default WordPress collation. Probably this person had some reason to change it.

    In other words, WordPress hasn’t “accent sensitive” searches by default, but probably your collation was changed in the database, and you have “accent sensitive” searches.

Viewing 1 replies (of 1 total)
  • The topic ‘Search with special characters’ is closed to new replies.