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

[Dag H. Wanvik]

"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 ;)