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 Sat, 31 Mar 2007 23:44:43 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

------------------------------------------------------------------------------
  http://www.nabble.com/Collation-feature-discussion-tf3418026.html#a9559634
  
  == Collation Determination ==
+ In Derby 10.3, there will be two character sets associated with the database. These 2 character
sets will have identical character repertoire(UCS) but they may have different collation associated
with them depending on the value of JDBC url attribute COLLATION. The 2 character sets will
be 
+ 1)USER character set - collation of UCS_BASIC/TERRITORY_BASED depending on the value of
jdbc url attribute COLLATION specified at create database time.
+ 2)SQL_IDENTIFIER character set - collation of UCS_BASIC.
+ 
+ As per SQL spec, Section 11.1<schema definition>, there is an optional syntax to associate
a character set for a schema at create schema time. Syntax Rule 5 says that if a character
set is not specified by the user, then the character set associated with schema is implementation
defined. In Derby 10.3, system schemas will be associated with SQL_IDENTIFER character set
and all the user schemas will be associated with USER character set. Futher on, 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, all the user character columns will
pick up the collation associated with USER character set and all the system character columns
will pick the up the collation associated with SQL_IDENTIFIER character set. 
  
  
  == Outstanding items ==

Mime
View raw message