Re: [jira] Commented: (DERBY-3080) With TERRITORY_BASED collation, when multiple characters map to a single collation element '_' matches a single collation element rather than a single character

[Mamta Satoor]

Thanks, Dag, for taking the time to follow this jira entry.

mamta


On 9/26/07, Dag H. Wanvik <[EMAIL PROTECTED]> wrote:
>
> "Mamta A. Satoor (JIRA)" <[EMAIL PROTECTED]> writes:
>
> > So in Norway, the character column (say c1) definition for 'aa' will
> > be CHAR(2) and looking at SQL spec, CHAR_LENGTH for that character
> > column will return 2. But when column c1 is used in a collation
> > related operation, for instance, c1 LIKE '_', we will use the
> > collation of the Norway locale and 'aa' will be a match to '_'.
>
> For what it's worth, this sounds right to me.
>
> Dag
> Norwegian ;)
>