Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: <derby-dev@db.apache.org>
Message-ID: <32957788.1182543506188.JavaMail.jira@brutus>
Date: Fri, 22 Jun 2007 13:18:26 -0700 (PDT)
From: "Kathey Marsden (JIRA)" <jira@apache.org>
To: derby-dev@db.apache.org
Subject: [jira] Commented: (DERBY-2865) With TERRITORY_BASED collation
 LENGTH function does not return correct number of characters for Norwegian
 'aa'
In-Reply-To: <31613561.1182539005854.JavaMail.jira@brutus>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit


    [ https://issues.apache.org/jira/browse/DERBY-2865?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12507496 ] 

Kathey Marsden commented on DERBY-2865:
---------------------------------------

So our doc says
_ matches one character in the corresponding position in the character expression.

http://db.apache.org/derby/docs/dev/ref/rrefsqlj23075.html#rrefsqlj23075

Do we need to change the doc to say it matches a single collation element?


> With TERRITORY_BASED collation LENGTH function does not return correct number of characters for Norwegian 'aa'
> --------------------------------------------------------------------------------------------------------------
>
>                 Key: DERBY-2865
>                 URL: https://issues.apache.org/jira/browse/DERBY-2865
>             Project: Derby
>          Issue Type: Bug
>          Components: SQL
>    Affects Versions: 10.3.0.0
>            Reporter: Kathey Marsden
>            Priority: Minor
>
> For territory=no_NO and collation=TERRITORY_BASED, 'aa' should be a single character but the length function reports it as two characters.
> ij> connect 'jdbc:derby:nordb;create=true;territory=no_NO;collation=TERRITORY_BASED';
> ij(CONNECTION1)> create table t (vc varchar(30));
> 0 rows inserted/updated/deleted
> ij(CONNECTION1)> insert into t values('aarg');
> 1 row inserted/updated/deleted
> ij(CONNECTION1)> select vc, length(vc) from t2;
> ERROR 42X05: Table/View 'T2' does not exist.
> ij(CONNECTION1)> select vc, length(vc) from t;
> VC                            |2
> ------------------------------------------
> aarg                          |4
> 1 row selected
> SUBSTR and CHAR functions have the same issue
> ij> values (SUBSTR('aarg',1,3));
> 1
> ----
> aar
> ij> values (CHAR('aarg',3));
> 1
> ----
> aar

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.