How to implement the accent/diacritic insensitive search in Sqlite?

Question

Is there a way to do an accent/diacritic insensitive search in sqlite?

Googling, I've found this, but I sincerely don't know how to create my "collation function" in C#. I'm trying create the pt-br collation for Sqlite...

Answer 1

A related question was answered here.

Answer 2

While it's possible to write your own collation, that might easily be slower than using a suitable system-supplied one -- doesn't SQL_Latin1_General_CP1_CI_AS serve your needs, for example? If it does, just use suitable COLLATE clauses (be that on your SELECT or CREATE TABLE queries...) and you should be all set.