[Zope] case insensitive searches

Maggie Shapland Maggie.Shapland@bristol.ac.uk
Thu, 18 Jan 2001 10:09:38 +0000


you didnt read the rest of the message or my example. Its all very well
using the sql lower function, but if you cant force the user to type 
the input in lower case you are wasting your time. However, I have now 
cracked it, as a later message to the group shows, but only in the 
report dtml, not in the sql method. See my web page for further details
On Wed, 17 Jan 2001 22:13:51 +0100 (CET) Dieter Maurer 
<dieter@handshake.de> wrote:

> Maggie Shapland writes:
>  > How does one do a case-insensitive search using sql 
>  > methods when the underlying database is case-sensitive?
> Oracle, e.g., provides functions "LOWER" and "UPPER"
> that you can use in SQL expressions.
> They can be used to implement case-insensitive searches.
> 
> Look at the list of built-in functions for your database.
> 
> 
> Dieter
> 

----------------------
Maggie Shapland, Computing Service, University of Bristol, Tyndall Av, 
Bristol BS8 1UD
Tel: 0117-9289869 (Int 9869)
Email: Maggie.Shapland@bristol.ac.uk
Web page: http://www.cse.bris.ac.uk/~ccmjs/
1925 Lanchester 21, 1925 Talbot 10/23, 1929 Peugeot 190S, 1986 Moss 
Monaco