Message: A new issue has been created in JIRA.
--------------------------------------------------------------------- View the issue: http://issues.apache.org/jira/browse/DERBY-27 Here is an overview of the issue: --------------------------------------------------------------------- Key: DERBY-27 Summary: UCASE/LCASE function should change case according to database locale, but uppercases according to the JVM locale. Type: Bug Status: Unassigned Priority: Minor Project: Derby Components: SQL Versions: 10.0.2.0 Assignee: Reporter: Ramandeep Kaur Created: Fri, 1 Oct 2004 3:37 PM Updated: Fri, 1 Oct 2004 3:37 PM Description: Opening this bug on behalf of Lynh Nguyen. ------------------------------------------------- The doc says UCASE/LCASE should change case according to the db locale. In a turkish db UCASE Should uppercase i to an upper dotted i and lowercase I to a lower non dotted i, but it changes the case in the JVM locale. For example ij in the us: ij> connect 'trdb;create=true;locale=tr_TR'; ij> values UCASE('i'); 1 - I 1 row selected ij> values LCASE('I'); 1 - i 1 row selected If I set the jvm locale to turkish I get the turkish characters. $ java -Duser.language=tr -Duser.region=TR org.apache.derby.tools.ij ij> connect 'jdbc:derby:trdb'; ij> values UCASE('i'); 1 - ? 1 row selected --------------------------------------------------------------------- JIRA INFORMATION: This message is automatically generated by JIRA. If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa If you want more information on JIRA, or have a bug to report see: http://www.atlassian.com/software/jira
