Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: <derby-dev@db.apache.org>
Message-ID: <22421933.1180469835639.JavaMail.jira@brutus>
Date: Tue, 29 May 2007 13:17:15 -0700 (PDT)
From: "Mamta A. Satoor (JIRA)" <jira@apache.org>
To: derby-dev@db.apache.org
Subject: [jira] Created: (DERBY-2722) Set correct collation type and
 derivation for result character string types from CHAR, VARCHAR and
 XMLSERIALIZE functions
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit

Set correct collation type and derivation for result character string types from CHAR, VARCHAR and XMLSERIALIZE functions
-------------------------------------------------------------------------------------------------------------------------

                 Key: DERBY-2722
                 URL: https://issues.apache.org/jira/browse/DERBY-2722
             Project: Derby
          Issue Type: New Feature
          Components: SQL
    Affects Versions: 10.3.0.0
            Reporter: Mamta A. Satoor
            Assignee: Mamta A. Satoor


As per the wiki page http://wiki.apache.org/db-derby/BuiltInLanguageBasedOrderingDERBY-1478, assign correct collation type for results of CHAR, VARCHAR and XMLSERIALIZE functions. The rule as copied from the wiki page is as follows
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. 


-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.