[sqlite] Accented chars in Android embeded Sqlite.

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] sqlite3 datatype

On 11 Aug, Gerry Snyder wrote: fred238 wrote: Gerry Snyder a écrit : fred238 wrote: Is necessary to set column datatype in sqlite3 ? Is better to use class storage in sqlite3 (TEXT, NUMERIC, INTEGER, REAL, NONE) ? Check out http://www.sqlite.org/datatype3.html and ask again here if yu

[sqlite] Query on sorting

Hi, I'm developing a small reception application for staff to use. The app records visitors signing in and out of the building. CREATE TABLE av2 ( Activity_ID INTEGER PRIMARY KEY, Timestamp TIMESTAMP, Visitor_ID VARCHAR(8), Action VARCHAR(1), Message VARCHAR(255)); insert into av2