db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From derby-...@db.apache.org
Subject [jira] Created: (DERBY-27) UCASE/LCASE function should change case according to database locale, but uppercases according to the JVM locale.
Date Fri, 01 Oct 2004 22:37:32 GMT
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


Mime
View raw message