db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Mamta Satoor" <msat...@gmail.com>
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 Thu, 27 Sep 2007 06:05:05 GMT
Thanks, Dag, for taking the time to follow this jira entry.

mamta


On 9/26/07, Dag H. Wanvik <Dag.Wanvik@sun.com> wrote:
>
> "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