db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Kathey Marsden (JIRA)" <j...@apache.org>
Subject [jira] Created: (DERBY-2865) With TERRITORY_BASED collation LENGTH function does not return correct number of characters for Norwegian 'aa'
Date Fri, 22 Jun 2007 19:03:25 GMT
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



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


Mime
View raw message