Peter Eisentraut wrote:
>
> Hiroshi Inoue writes:
>
> > Hmm * string1 = string2 * doesn't imply * string1 LIKE string2 * ?
>
> In the current implementation of LIKE, you're right. The SQL standard
> allows for the possibility that "[d]epending on the collating sequence,
> two strings may compare as equal even if they are of different lengths or
> contain different sequences of characters." However, I doubt that this
> can really happen in practice. For example, in some collating sequences
> (such as en_US), characters with diacritic marks (accents) are "more
> equal" than others, but in the end there's always a tie breaker. Or do
> you know an example where this really happens?
I can see the examples in a documentation M$ SQL Server though
I can't try it in reality.
For example ignore case(low/high) ignore accents
I don't think they are strange as collating sequences.
You are establishing a pretty big mechanism and I think
you should clarify the assumption.
Please tell me the assumption.
I can think of the followings.
1) Because the current implementaion of LIKE isn't locale-aware, we should be compatible with it for ever.
2) strcoll(str1, str2) == 0 means strcmp(str1, str2) == 0 in any locale.
regards,
Hiroshi Inoue