[EMAIL PROTECTED] wrote:
Note that SQLite has historically resolved an ambiguous collation
by choosing the collation of the left operand. I'll need to preserve
that behavior in order to maintain backwards compatibility.
Richard,
Perhaps you could add (yet another | a) pragma that would allow a user
to specify they want the database to use the SQL standard rules for
selecting the collation to use. It would default to off for backwards
compatibility, but could be turned on for standards conformance. This
should probably be a sticky pragma (like page_size) that stays with the
database so that the standard collations rules can be used in triggers etc.
Dennis Cote
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------