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

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

[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