[jira] Commented: (DERBY-2656) Run suites.All against a collated database

["Kathey Marsden (JIRA)" <ji...@apache.org>]

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

Kathey Marsden commented on DERBY-2656:
---------------------------------------

I think ascii is the same as the default except for my favorite norwegian character 'aa' which is one character and sorts after z in Norway and is two and sorts before z in the default encoding.

ij> connect 'jdbc:derby:wombat;create=true;collation=TERRITORY_BASED;territory=no';
WARNING 01J01: Database 'wombat' not created, connection made to existing database instead.
ij> create table t (vc varchar(30));
0 rows inserted/updated/deleted
ij> insert into t values('acorn');
1 row inserted/updated/deleted
ij> insert into t values('aacorn');
1 row inserted/updated/deleted
ij> insert into t values('zebra');
1 row inserted/updated/deleted
ij> select * from t order by vc;
VC
------------------------------
acorn
zebra
aacorn


> Run suites.All against a collated database
> ------------------------------------------
>
>                 Key: DERBY-2656
>                 URL: https://issues.apache.org/jira/browse/DERBY-2656
>             Project: Derby
>          Issue Type: Test
>          Components: Test
>    Affects Versions: 10.3.0.0
>            Reporter: Kathey Marsden
>         Assigned To: Kathey Marsden
>            Priority: Minor
>             Fix For: 10.3.0.0
>
>         Attachments: DERBY-2656_diff.txt
>
>
> It would be good to leverage the existing tests to exercise the collation code.  Investigate running all the tests against a collated database.
> Kathey

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