When I search for a keyword like "Hígado," it works. However, if I search for "higado" (without the accent), no results are found.
In Spanish, it’s common to use accents, but sometimes people type the word without accents, such as "Hígado" versus "higado." Unfortunately, the search currently doesn’t return results for words that lack the accent. I need the search to be insensitive to accents and other special characters.
Search word with accent
Search the same word without accent
Background (please complete the following information):
NodeJS Version 20.9.0
Postgres Version PostgreSQL 14.13 (Ubuntu 14.13-0ubuntu0.22.04.1) on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu 11.4.0-1ubuntu1~22.04) 11.4.0, 64-bit
Describe the bug
The problem is in the filter:
accents sensitive
Should be:
accents insensitive
When I search for a keyword like "Hígado," it works. However, if I search for "higado" (without the accent), no results are found.
In Spanish, it’s common to use accents, but sometimes people type the word without accents, such as "Hígado" versus "higado." Unfortunately, the search currently doesn’t return results for words that lack the accent. I need the search to be insensitive to accents and other special characters.
Search word with accent
Search the same word without accent
Background (please complete the following information):