[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]
-----------------------------------------------------------------------------

Reply via email to