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