Mailing List Archive


Back to the month index Back to the list index
Bernhard Fuerst (fuerst@hrz.tu-freiberg.de)
Tue, 10 Sep 1996 23:44:22 +0200 

Message-Id: <9609102144.AA17560@mocha.bunyip.com>
Date: Tue, 10 Sep 1996 23:44:22 +0200
From: fuerst@hrz.tu-freiberg.de (Bernhard Fuerst)
Subject: Re: [mSQL] case sensitivity

>I'm using mSQL 1.0.16 as a backend to my web server. The database I've
>inherited and must serve on the web has strange, inconsistent rules for
>case among the various fields, so I'm interested in
>implementing case-insensitive searches.
>
>I grabbed from the Feb 96 list archives a patch contributed by Benjamin
>Jacquard (jacquard@lix.polytechnique.fr) but haven't applied it yet. I'm
>curious if the patch will break the server since the patch was written
>against mSQL 1.1.10. Anybody have experience with this?

Just change all "msql-1.0.10" references in the patch file to
"msql-1.0.16". You must apply the patch to the source *before* making
targets.

>Also, is this patch the best way to deal with case-insensitive searches
>or is there a better way (e.g. passing Perl regular expressions as search
>strings from my CGI)?

I'm for myself don't use the case-insensitive patch. I'm using PHP/FI
(http://www.vex.net/php/) as mSQL <-> httpd gateway. It allows turning a
string like "abc" into "[Aa][Bb][Cc]" in order to get a case insensitive
match.

bye,
Bernhard

                                   ,,,
                                   o o
-------------------------------ooo--O--ooo---------------------------------
 Bernhard Fuerst fuerst@geo.tu-freiberg.de
 TU Bergakademie Freiberg http://www.geo.tu-freiberg.de/

--------------------------------------------------------------------------
To remove yourself from the Mini SQL mailing list send a message containing
"unsubscribe" to "unsubscribe" to msql-list-request@bunyip.com. Send a message containing
"info msql-list" to majordomo@bunyip.com for info on monthly archives of
the list. For more help, mail owner-msql-list@bunyip.com NOT the msql-list!

--------------------------------------------------------------------------
To remove yourself from the Mini SQL mailing list send a message containing
"unsubscribe" to "unsubscribe" to msql-list-request@bunyip.com. Send a message containing
"info msql-list" to majordomo@bunyip.com for info on monthly archives of
the list. For more help, mail owner-msql-list@bunyip.com NOT the msql-list!