> > I see. But that really doesn't have anything to do with reality. In
> > fact, it completely undermines the transparency of the character set
> > encoding that we're probably trying to achieve.
>
> COLLATION being independent of character set is a separate problem
> from COLLATION being _defined_ on character set - without a known
> character set I can't see how you can define it.
> i.e. "COLLACTION for any 8-bit charset" just does not make sense.
Correct. IGNORE_CASE collation will not apply to some languages those
do not have upper/lower case concept such as Japanese.
--
Tatsuo Ishii