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 "lite" from
SQLite.
Ok, I can understand it.
You can create your own COLLATE function and make SQLite use it. Take
a look here:
http://www.sqlite.org/capi3ref.html#sqlite3_create_collation
Anybody knows if there is some Perl way to do that? (using DBD::SQLite
it doesn't seem available).
Cheers
Alberto
--
Alberto Simões
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
