android - How to SQL compare columns when one has accented chars? -

I have two SQLite tables, I would love to be included on a name column. There are pronunciation characters in this column, so I'm thinking how I can compare to join them. I would like to like the left utterances for comparison of the work.

You can use a collation Comparisons (such as ignoring the case, ignoring the accent) can affect. Only a few inclusions are built in SQLite, although you can add your own.

SqlLite,

Edit: Given that it seems suspicious that the Android UDF and the computed column This is another way:

• Add another column to your table, generalized name
• When your app writes rows to your table, this name Changes, removes accents, and makes other changes, it saves results in normalized.
• You use the normalized name to join

Due to being normal, now the normal function is being done in Java, you should have some restrictions in coding . There are several examples to remove the pronunciation in Java.