Ignore accents in characters during search

[AristeoMontoya]

What is the problem you are trying to solve with this feature?

In some languages like spanish for example, we make extensive use of accented characters (diacritics) like in the word árbol.

The issue is that if I have an item in homebox called árbol de navidad, and search for the word arbol (meaning without accents), it doesn't match árbol. This is a minor inconvenience but is specially annoying on mobile.

What is the solution you are proposing?

A few options

I spent a bit looking into this and looking around in the code for ways to fix this but in the end I rather discuss some of the options that I've found so far with the core team, specially since I have limited experience with sqlite and golang.

Correct me if I'm wrong but homebox is using sqlite internally and uses atlas for migrations, and collation doesn't seem to be available for sqlite, at least not during creation but looks like sqlite does support collation for queries.

After a few google searches I stumbled across two common approaches:

1. Storing the same data without accents in a different column.
2. Write a custom collate function that strips accents, which comes with performance implications for larger inventories.

Wanted to bring it up to discuss this and other potential approaches if any.

What alternatives have you considered?

No response

Additional context

No response

Contributions

• I have searched through existing issues and feature requests to see if my idea has already been proposed.
• If this feature is accepted, I would be willing to help implement and maintain this feature.
• If this feature is accepted, I'm willing to sponsor the development of this feature.