For many reasons, the project I’m working on require to use SQlite databases. I have implemented all the functionality and everything works very well.
The problem is that I need to enable searching regardless accents and tildes. In the database, all records are saved with their respective accents/tildes. For example, "Gómez".
What I want is that when I search for "gomez", the database returns the record "Gómez". This is not working at the moment, doing normal searches (using Criteria and LIKE conditions).
I have tested many things, but none of them work. I know that this is relatively easy with Mysql, but I need to use SQlite.
Does any of you how ti fix that?
Thanks and best regards.