[sqlite] Re: How to specify collating sequences in an expression.
[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] -
[sqlite] Re: How to specify collating sequences in an expression.
[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] -