Subject Re: [Firebird-Architect] Re: UTF-8 (various)
Author Lester Caine
Jim Starkey wrote:

> Good. Let's accept the idea that there are different flavors of case
> insensitivity. I think we can also agree that a collation is required
> to define case insensitivity for a particular language. The question is
> whether case insensitivity is, in fact, just a collation, or something a
> little stronger. The difference, I think, is in the definition of the
> equality operator. For field declared as case insensitive, two values
> can be different but still equal. Furthermore, a comparison of field
> that is case insensitive to a case sensitive value must be performed
> with case insensitivity. Should the same rules apply to simple
> collations? It seems funny that a client can request a case insensitive
> order of values but not a case insensitive retrieval by value.

The simple stuff is here
http://www.unicode.org/charts/case/index.html
But I'm not sure how it ties in with normalization
http://www.unicode.org/charts/normalization/index.html


--
Lester Caine
-----------------------------
L.S.Caine Electronic Services