Ignore punctuation on local database search


How's possible to search in local database ignoring punctuation?


Search: "Antonio"

Return: "António"


Hello Otacon,

Are you using SQL Server? For what i understand you want to retrieve the records that have and have not punctuation. Is that it?

Best regards,

Rafael Valente

Hi Rafael,

It's on local database for mobile applications. So, I think it's SQLite


Hi Otacon,

The best way I can think of is to add a new attribute to the entity to store the name without punctuation. Then search over that attribute. Don't forget to also remove the punctuation in the search criteria.