Search problem when accent in category

Hi @cantbutron

This error is related to the define('DB_COLLATE', ''); constant which is set to null when you install WordPress. This causes collation in the database to be set to the default version mostly it is latin1_swedish_ci.

To Fix the problem you need to change the collation in your MySQL, but this may be problematic. Here is a tutorial on how to change the collation by using PHPMyAdmin tool.

However, I do not recommend doing this if you are not comfortable with it. Of course, before all such activities, you should make a full backup of the website including the database, to be sure that if something goes wrong, the website will be restored.

Also, you can set define( 'DB_COLLATE', 'utf8_spanish_ci' ); in wp-config.php but this will work only for newly added data.

Regards,
Kris

Hi again and thanks for your answer,

My database collation is utf8mb4_unicode_ci. This collation is recommended for special characters such as “?”, “á”, “é” and even emojis. Obviously, I can’t change that collation because other features would fail and I don’t think it’s the best solution.

If it issue is a character problem due to its encoding in the database, this problem would also extend to the search for products, but this error only occurs in categories. Using the previous example, if I have a category “Grabación” and a product “Micrófono para grabación”, searching for “Grabacion” without an accent only shows the product and not the category.

The plugin is able to search for words with an accent in the database even if the search is done without an accent, but the part of the plugin that searches in the categories does not work correctly.

If it is necessary I can review the code in search of the problem.

Thanks in advance