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 DanDebrunner
Date Fri, 08 Jun 2007 22:00:24 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 DanDebrunner:
http://wiki.apache.org/db-derby/BuiltInLanguageBasedOrderingDERBY-1478

------------------------------------------------------------------------------
  
  5)Result character string types from UPPER, LOWER, TRIM(LTRIM, RTRIM), SUBSTR will have
the same collation as their operand. This comes from SQL spec Section 6.29 <string value
function> Syntax Rules 8, 8, 11d, 4 respectively). The collation derivation will be implicit.

  
- 6)CHAR, VARCHAR and XMLSERIALIZE functions do not look like they are defined in the SQL
spec. Their behavior can be defined as similar to CAST ie, the result character string of
CHAR/VARCHAR/XMLSERIALIZE will have the same collation as current schema's character set.
The collation derivation will be implicit.
+ 6)CHAR, VARCHAR functions do not look like they are defined in the SQL spec. Their behavior
can be defined as similar to CAST ie, the result character string of CHAR/VARCHAR will have
the same collation as current schema's character set. The collation derivation will be implicit.
+ 
+ 6a) XMLSERIALIZE (defined in SQL Standard Part 14) has the declared type of the explicit
character type in the function and thus falls under the rules defined in 3).
  
  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. 
  

Mime
View raw message