[EMAIL PROTECTED] wrote:
(2) How do other SQL engines do this kind of thing?
MS SQL Server supports
a=b collate CollationName
syntax. There are a few examples at
http://msdn2.microsoft.com/en-us/library/ms179886.aspx
This article also specifies a rather complicated set of rules for
determining which collation should be used for a given comparison.
MS SQL also supports defining multiple indexes on the same table and
field(s), differing only in collation (and the optimizer is smart
enough, most of the time, to use these indexes appropriately). I haven't
tried it with SQLite, maybe it's also supported.
Igor Tandetnik
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------