Re: [sqlite] Sorting with latin1 characters

2007-03-31 Thread Alberto Simões
On 3/31/07, Nuno Lucas <[EMAIL PROTECTED]> wrote: On 3/31/07, Alberto Simões <[EMAIL PROTECTED]> wrote: That is by design. SQLite only knows how to sort ASCII strings. The problem is that almost every language has it's own idea of how to sort, and making SQLite know about all this would take the

Re: [sqlite] Sorting with latin1 characters

2007-03-31 Thread Nuno Lucas
On 3/31/07, Alberto Simões <[EMAIL PROTECTED]> wrote: Hi I am trying to sort results from a SELECT using ORDER BY. That column includes latin1 characters, and SELECT returns the entries with accented characters at the end of the list. That is by design. SQLite only knows how to sort ASCII stri

Re: [sqlite] Using the Sqlite Btree Backend directly

2007-03-31 Thread Cesar Rodas
On 31/03/07, Cesar Rodas <[EMAIL PROTECTED]> wrote: On 30/03/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > <[EMAIL PROTECTED]> wrote: > > > > > > > > I'm looking at using Sqlite as a storage backend for a program. > > > > Using SQL is a little bit overkill > > > > > > why bother with

Re: [sqlite] Using the Sqlite Btree Backend directly

2007-03-31 Thread Cesar Rodas
On 30/03/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: <[EMAIL PROTECTED]> wrote: > > > > > > I'm looking at using Sqlite as a storage backend for a program. > > > Using SQL is a little bit overkill > > > > why bother with SQLite then? Use the right tool for the job > > -- use BerkeleyDB.

[sqlite] Sorting with latin1 characters

2007-03-31 Thread Alberto Simões
Hi I am trying to sort results from a SELECT using ORDER BY. That column includes latin1 characters, and SELECT returns the entries with accented characters at the end of the list. I am using DBD::SQLite, so I am not sure if I tested correctly the change of environment variables to see if sqlite