Hi,
How's possible to search in local database ignoring punctuation?
E.g.:
Search: "Antonio"
Return: "António"
Thanks,
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.