You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-dev@db.apache.org by de...@db.apache.org on 2004/10/02 00:37:32 UTC
[jira] Created: (DERBY-27) UCASE/LCASE function should change case according to database locale, but uppercases according to the JVM locale.
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
[jira] Closed: (DERBY-27) UCASE/LCASE function should change case according to database locale, but uppercases according to the JVM locale.
Posted by "Daniel John Debrunner (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-27?page=all ]
Daniel John Debrunner closed DERBY-27:
--------------------------------------
Test output shows it is ok.
> 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
[jira] Resolved: (DERBY-27) UCASE/LCASE function should change case according to database locale, but uppercases according to the JVM locale.
Posted by "Daniel John Debrunner (JIRA)" <de...@db.apache.org>.
[ 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