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.