db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Daniel John Debrunner (JIRA)" <derby-...@db.apache.org>
Subject [jira] Resolved: (DERBY-27) UCASE/LCASE function should change case according to database locale, but uppercases according to the JVM locale.
Date Wed, 02 Nov 2005 20:06:55 GMT
     [ http://issues.apache.org/jira/browse/DERBY-27?page=all ]
     
Daniel John Debrunner resolved DERBY-27:
----------------------------------------

    Resolution: Invalid

Bug was fixed before code was open sourced. Test exists, i18n/caseI_tr_TR.sql

Entered by mistake from the Cloudscape bug tracking system once the code was open sourced.

> UCASE/LCASE function should change case according to database locale, but uppercases
according to the JVM locale.
> -----------------------------------------------------------------------------------------------------------------
>
>          Key: DERBY-27
>          URL: http://issues.apache.org/jira/browse/DERBY-27
>      Project: Derby
>         Type: Bug
>   Components: SQL
>     Versions: 10.0.2.0
>     Reporter: Ramandeep Kaur
>     Priority: Minor

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

-- 
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
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira


Mime
View raw message