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 05:55:26 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

------------------------------------------------------------------------------
  
  7)For user defined functions' that return character string type, the return type's collation
will have the same collation as of the character set of the schema that the function is defined
in. The collation derivation will be implicit. 
  
- 8)JDBC parameters (ie. ?) where the type of the parameter is a character type will have
the same collation as of the character set of the schema where the statement is prepared.
The collation derivation will be implicit. 
+ 8)JDBC parameters (ie. ?) where the type of the parameter is a character type will get their
collation from the context, just like it is done for other attributes of a character type
(like nullability, length etc. More info about how this works can be found at http://db.apache.org/derby/docs/10.2/ref/rrefsqlj1083019.html).
Also look at the thread http://www.nabble.com/Collation-and-parameter-markers-%28-%29-tf3866040.html#a10952369
  
  9)For CURRENT_USER, SESSION_USER, SYSTEM_USER, SQL spec Section 6.4 Syntax Rule 4 says that
their collation type is the collation of character set SQL_IDENTIFIER. In Derby's case, that
will mean, the collation of these functions will be UCS_BASIC. The collation derivation will
be implicit. 
  

Mime
View raw message