Hello Yahoo, Another possible solution seeing you're on the Android platform and writing in Java is to use a less high tech solution and store an additional column with a copy of the text you're searching where you've stripped the accents out and use that for the search instead. It would use additional storage but would give you the control you're after in a simple manner.
Regards, Karl Edwall Wednesday, May 16, 2012, 11:23:25 AM, you wrote: Y> Hi everyone! Y> Im Brazilian, also, Android Dev. Y> Im in a struggle with Sqlite and accented chars such as á or é. Y> What Im trying to do is a select with where accent insensitive. Y> For months I have having research over and over the internet to accomplish Y> that, but, unfortunately unsuccessful. Y> Y> What I need is something like this: Y> select * from table where column like a% Y> and result be: Y> agora Y> água Y> através Y> and so on Y> Y> Its possible? Or better to commit suicide ;-) Y> Thanks in advance Y> Youre all aces in my book. Y> Y> _______________________________________________ Y> sqlite-users mailing list Y> sqlite-users@sqlite.org Y> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users