Re: unicode and sorting(at least)

On Wed, 23 Jun 2004, Dennis Gearon wrote:

> This is what has to be eventually done:(as sybase, and probably others do it)
>
>     http://www.ianywhere.com/whitepapers/unicode.html

Actually, what probably has to be eventually done is what's in the SQL
spec.

Which is AFAICS basically:
 Allow multiple encodings
 Allow multiple character sets (within an encoding)
 Allow one or more collations per character set
 Allow columns to specify character set and collation
 Allow literals in multiple character sets
 Allow translations and encoding conversions (as supported)
 Allow explicit COLLATE clauses to control ordering and comparisons.
 Handle identifiers in multiple character sets

plus some misc things like allowing sets that control the default
character set for literals for this session and such.