db-derby-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Apache Wiki <wikidi...@apache.org>
Subject [Db-derby Wiki] Update of "BuiltInLanguageBasedOrderingDERBY-1478" by MamtaSatoor
Date Tue, 05 Jun 2007 02:21:35 GMT
Dear Wiki user,

You have subscribed to a wiki page or wiki category on "Db-derby Wiki" for change notification.

The following page has been changed by MamtaSatoor:
http://wiki.apache.org/db-derby/BuiltInLanguageBasedOrderingDERBY-1478

------------------------------------------------------------------------------
  
  Following lists the collation type association for various occurences of character string
types and for operations involving character string types in Derby 10.3
  
- 1)String literal - USER will be the character set of string literals. And collation type
will be the default collation of USER which can be UCS_BASIC/TERRITORY_BASED. The collation
derivation will be implicit.
+ 1)String literal - USER will be the character set of string literals. And collation type
will be the default collation of USER which can be UCS_BASIC/TERRITORY_BASED. The collation
derivation will be implicit. June 4th 2007 The current code in Derby 10.3 uses the collation
type of current compilation schema for string literals rather than using the collation type
associated with USER character set. There is a Jira entry DERBY-2731 and a thread  http://www.nabble.com/Collation-and-string-literals-limitation-in-SQL-standard--tf3868448.html#a10959872
started by Dan to see what should be the correct collation type for string literals. 
  
  2)<column definition> (of character string type) SQL spec Section 11.1 <schema
definition>, General Rule 3 specifies that the character set associated with schema is
used as the default character set for all <column definitions>. Based on this, character
columns in user tables will have USER character set associated with them and hence collation
type of UCS_BASIC/TERRITORY_BASED. The collation derivation will be implicit. 
  

Mime
View raw message