Bug #5885 Case insensitive in Order By clause
Submitted: 4 Oct 2004 19:11 Modified: 5 May 2005 7:46
Reporter: Steve Ho Email Updates:
Status: No Feedback Impact on me:
None 
Category:MaxDB Severity:S4 (Feature request)
Version:all OS:Any (all)
Assigned to: Assigned Account CPU Architecture:Any

[4 Oct 2004 19:11] Steve Ho
Description:
It would be really helpful if MaxDB has an option for case insensitive sorting in the Order By clause without having to use the Upper/Lower functions. It could be a session parameter which we can turn on and off. We have a big application written for Microsoft SQL. When we switch it to use MaxDB, everything works fine except for the case insensitivity issue. I know most db systems either are case insensitive by default or have a session switch to turn it on.

How to repeat:
n/a
[5 Apr 2005 7:46] Ulf Wendel
Hi Steve,

could you elaborate a little bit more why Mapchars won't do the trick for you?

Best regards,
Ulf
[5 May 2005 23:00] Bugs System
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".