[ http://issues.apache.org/jira/browse/DERBY-134?page=all ]

Andrew McIntyre reassigned DERBY-134:
-------------------------------------

    Assignee: Tomohito Nakayama

> Sorted string columns are sorted in a case sensitive way
> --------------------------------------------------------
>
>                 Key: DERBY-134
>                 URL: http://issues.apache.org/jira/browse/DERBY-134
>             Project: Derby
>          Issue Type: Improvement
>          Components: JDBC
>         Environment: Windows (XP & 2000)
>            Reporter: Navin Melville
>         Assigned To: Tomohito Nakayama
>             Fix For: 10.1.1.0
>
>         Attachments: DERBY-134.20050328_2.patch
>
>
> Sorted string columns are sorted in a case sensitive way. In other databases 
> we achieve case insensitive search by calling the lower() function in order 
> by. However, in Derby lower function cannot be called on parameters specified 
> in order by. You can do select lower(name) … but not order by lower(name).

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


Reply via email to