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, 04 Sep 2007 20:50: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 MamtaSatoor:
http://wiki.apache.org/db-derby/BuiltInLanguageBasedOrderingDERBY-1478

------------------------------------------------------------------------------
  
  4)<cast specification> Section 6.12 Syntax Rule 10 says that if the target data type
of CAST is character string type, then collation type of result character string of CAST specification
is the collation of the character set of the target data type. Based on 3) above, that will
be the collation of the current compilation schema's character set. The collation derivation
will be implicit. 
  
- 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.

+ 5)Result character string types from UPPER, LOWER, TRIM(LTRIM, RTRIM), SUBSTR will have
the same collation type and derivation as their operand. This comes from SQL spec Section
6.29 <string value function> Syntax Rules 8, 8, 11d, 4 respectively).  
  
  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 compilation schema's character set. The collation derivation
will be implicit.
  

Mime
View raw message