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 Wed, 11 Apr 2007 18:58:15 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

------------------------------------------------------------------------------
  
  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 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.
+ 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.
  
  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