Subject Collation Sequences
Author Jim Starkey
Does anybody know what the official rules are for
comparisons of string of different collating sequences?
Or comparing a string with a collating seqeuence with
string without an explicit collating sequence (for example,
a string literal)?

Also, is the collation clause on a comparison operator a
modifier on a value or the comparison operator itself?

And while we're at it, what is/should be the collation
sequence of a sql case expression of different collation

Mr. Schnepper? Ms. Brown?

I will accept answers in three parts:

1. What does the standard say?
2. What does Firebird do?
3. With the advantage of hindsight, what is
the right answer?

Jim Starkey