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, 03 Apr 2007 17:36:34 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

------------------------------------------------------------------------------
  
  '''[[GetText(Comment from Dan)]]''' The "current schema's" character set, or the character
set of the schema the function is defined in? And if it's the current schema, is it current
at function definition time, or current when used?
  
+ 8)JDBC parameters (ie. ?) where the type of the parameter is a character type will have
the same collation as current schema's character set, based on 3) above.
  
- 8)JDBC parameters (ie. ?) where the type of the parameter is a character type will have
the same collation as current schema's character set, based on 3) above.
+ '''[[GetText(Comment from Army)]]''' Using the character set of the schema where the statement
is prepared will make the behavior consistent rather than using the character set of the schema
where the prepared statement is executed.
  
  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