jp <sqlamigo-/[EMAIL PROTECTED]> wrote:
So, is creating an index with "collate" useless if you didn't specify the collate at the table level?
Not entirely useless: the index may still be used to satisfy "ORDER BY field COLLATE collation" clause. Also, Dr. Hipp appears to be working on allowing syntax like "WHERE field = expr COLLATE collation" to expicitly specify collation for individual comparisons.
Igor Tandetnik
----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
