Hi everyone!

I’m Brazilian, also, Android Dev.

I’m in a struggle with Sqlite and accented chars such as ‘á’ or ‘é’.

What I’m trying to do is a select with where accent insensitive.

For months I have having research over and over the internet to accomplish
that, but, unfortunately unsuccessful.

 

What I need is something like this:

select * from table where column like ‘a%’

and result be:

agora

água

através

and so on

 

It’s possible? Or better to commit suicide ;-)

Thanks in advance

You’re all aces in my book.

 

_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to