Hi Ben,
>From the syntax page:
http://www.sqlite.org/lang.html
There are mentions of how to use the COLLATE keyword for CREATE TABLE,
CREATE INDEX, and SELECT.
For example, a select statement might end with:
....ORDER BY lastname COLLATE NOCASE;
I think NOCASE and BINARY are built-in collation sequences, though I'm not
sure where those are listed.
Donald Griggs
Opinions are not necessarily those of Misys Healthcare Systems nor its board
of directors.
-----Original Message-----
From: Ben Clewett [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 22, 2005 6:37 AM
To: [email protected]
Subject: [sqlite] Newbe question on collations
Dear SQLite,
Thanks for providing the application of the decade. SQLite is simply
excellent. Thanks for all the work.
I am using SQLite as a bastion database between an application and
MySQL. Which works very well, accept that the collations differ. MySQL
is case-insensitive.
I can't seem to find any information on the web site. Would any person
have some information on how to change the default collation, this would
be extremely useful.
Kind regards,
Ben Clewett.
