[
https://issues.apache.org/jira/browse/DERBY-2865?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Kathey Marsden closed DERBY-2865.
---------------------------------
> 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.1.4
> 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.
