Re: [sqlite] Re: [inbox] [sqlite] About ORDER BY results...

Michael Hunley wrote: At 07:14 PM 2/24/2004 +0100, Eric Morand wrote: Celine Céline Eric Marc Éric Zoe céline eric Éric éric This does NOT appear ordered to me... Moreover, it does not appear correct! "Éric" appears twice, once before "Zoe" and again before "éric". Why is that? It looks like

[sqlite] Change the behave of LIKE

Hi ! Sorry, I dont know English very well ...:( I need to get all rows with acents on some colums : SELECT ...FROM ... WHERE some_col LIKE 'sao paulo' and get : 'são Paulo', 'sao Paulo', 'são Paúlo', etc in other words, function LIKE consider : ã, â, á etc equal 'a' . I am thinking to do a

[sqlite] About ORDER BY results...

Hi to all, I've noticed a strange behavior with the SELECT...ORDER BY... statement. Maybe this is a feature but that still bugs me... Here is a part of my database : Table : Thirds Column : Name Entres : Eric, Céline, éric, Éric, Celine, Marc, eric, céline, Zoe. When I perform this query to

[sqlite] Patch for MingW32 build on Windows

Hi all - I'm attaching my very tiny diffs to make the MingW32 compile on Windows generate a good sqlite.dll and a sqlite.exe which uses the dll. It also produces a libsqlite.a so you can link in other apps. The zip contains: Length Date TimeName

Re: [sqlite] Concurrence in DB

Hello Thiago, http://www.sqlite.org/cvstrac/wiki?p=MultiThreading Regards, -- Tito On 24 feb 2004, at 10:31, Thiago Mello wrote: Hi, Im using Sqlite in my application, and I want to two process bem able to insert records in a table, SQLite support process concurrence, or I have to do this

[sqlite] Concurrence in DB

Hi, Im using Sqlite in my application, and I want to two process bem able to insert records in a table, SQLite support process concurrence, or I have to do this in my program? If I have to do this in my program some one have a idea how can I do this I tried to use some things already. Thanks,