db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Dag.Wan...@Sun.COM (Dag H. Wanvik)
Subject 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
Date Wed, 26 Sep 2007 23:15:46 GMT
"Mamta A. Satoor (JIRA)" <jira@apache.org> 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 ;)

Mime
View raw message