Ignore punctuation on local database search

Ignore punctuation on local database search

  

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

Solution

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.

Solution