db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Mamta A. Satoor (JIRA)" <j...@apache.org>
Subject [jira] Commented: (DERBY-2416) Provide a shell for a subclass of SQLChar which will use the passed Collator to do the collation rather than SQLChar's default collation of UCS_BASIC
Date Sun, 11 Mar 2007 07:39:09 GMT

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

Mamta A. Satoor commented on DERBY-2416:
----------------------------------------

commited DERBY2416_NewCharClassWithDifferentCollationSupport_diff_v2.txt patch with revision
516864. The commit comments are as follows

****** start of commit comment for revision 516864 **************
Patch for DERBY-2416 : Provide a shell for a subclass of SQLChar which will use the passed
Collator to do the collation rather than SQLChar's default collation of UCS_BASIC

This patch introduces a new class called CollatorSQLChar which extends SQLChar. The new class
has a RuleBasedCollator associated with it and that Collator object determines the collation.
A new format id is added for this class and code regarding format id has gone into RegisteredFormatIds,
StoredFormatIds and DTSClassInfo.

The new class is bare minimum at this point and new collation related methods will be added
to this class in later patches. This new class does not get used in Derby at this point. The
query compiler code will need to be changed so that this class can get some action. This will
happen in upcoming patches.

Dan had some suggestion on creating collation elements as required rather than doing it all
upfront. Dag also had suggestion on alternative implementation for array handling involved
with collation element creation. We agreed on tackling these issues once the basic functionality
is in for language based ordering.

****** end of commit comment for revision 516864 **************



> Provide a shell for a subclass of SQLChar which will use the passed Collator to do the
collation rather than SQLChar's default collation of UCS_BASIC
> -----------------------------------------------------------------------------------------------------------------------------------------------------
>
>                 Key: DERBY-2416
>                 URL: https://issues.apache.org/jira/browse/DERBY-2416
>             Project: Derby
>          Issue Type: New Feature
>          Components: SQL
>    Affects Versions: 10.3.0.0
>            Reporter: Mamta A. Satoor
>         Assigned To: Mamta A. Satoor
>         Attachments: DERBY2416_NewCharClassWithDifferentCollationSupport_diff_v1.txt,
DERBY2416_NewCharClassWithDifferentCollationSupport_diff_v2.txt, DERBY2416_NewCharClassWithDifferentCollationSupport_stat_v1.txt,
DERBY2416_NewCharClassWithDifferentCollationSupport_stat_v2.txt
>
>
> This jira entry is one of the tasks involved in implementing DERBY-2336.
> The existing SQLChar datatype has the Derby's default collation which is UCS_BASIC defined
on them. With Derby 10.3, we want to support an additional collation for char datatypes which
will be based on the territory. This jira issue is the placeholder for creating subclass of
SQLChar which will use the passed Collator to do the collation. The current use of this class
in Derby 10.3 will be for territory based collation but this class can be used in future for
other kinds of collations like case-insensitive etc.

-- 
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