Re: [sqlite] Accented chars in Android embeded Sqlite.

2012-05-17 Thread Karl Edwall
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

[sqlite] Accented chars in Android embeded Sqlite.

2012-05-16 Thread Yahoo
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.

Re: [sqlite] Accented chars in Android embeded Sqlite.

2012-05-16 Thread Richard Hipp
On Tue, May 15, 2012 at 9:23 PM, Yahoo bossco...@yahoo.com.br wrote: 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