This is cool if you are using English. But it's really nasty if you are
using a non-Ascii or extended Ascii alphabets. Conventions for the same
language may vary across countries. For example in France, accented
characters do not carry their accents when they are upper cased, but in
Canadian French they do carry their accents.

In Swedish, the (A with a circle over it) is considered equal to A. In
Norsk, it is considered a separate letter that comes after Z.

I'm in the middle of fighting with some of this, so I'm learning it the
hard way. Thank God I'm not trying to support Tibetian.

On Fri, 2004-11-12 at 17:30, Ray Jenkins wrote:
>
> We have used the contains sql term to do case insensitive searching
> here. ie. Select * from MyTable where Name contains 'Smith'
>
>
> On Fri, 12 Nov 2004 22:55:03 +0100, Uwe Grauer
> <mailinglists@...> wrote:
> > Myles Wakeham wrote:
> >
> >
> >
> > > I'm trying to determine the general conventions that developers use for
> > > searching Firebird (or any other SQL database) relating to upper/lower
> > > case
> > > searching.
> > >
> > > The data in our search fields will be stored as mixed Upper Case/Lower
> > > case
> > > textual data, but when we search for a matching value I'm not sure
> > > what the
> > > best strategy is for this. One of our developers wanted to develop a UDF
> > > for this, but I can't see why this is required.
> > >
> > > If I want to seach a text field for 'Smith', and the values in the
> > > database
> > > are referenced as 'SMITH', 'Smith', and 'smith' what is the best way to
> > > handle this in an application?
> > >
> > > Myles
> > >
> > > ===========================
> > > Myles Wakeham
> > > Director of Engineering
> > > Tech Solutions Inc.
> > > Scottsdale, Arizona USA
> > > Phone (480) 451-7440
> > > Web: www.techsol.org
> > >
> > If you want to do a case-insentitive search, you should put the field
> > all uppercase into a mirror
> > field for searching. You can do this in an Insert/Update Trigger. If you
> > use an Index of the mirror
> > field for searching, you can select with high speeds.
> > If you do not have much data to be searched, you could also use 'where
> > upper(tfield) = upper(seachtext)'.
> >
> > Uwe
> >
> >
> > Yahoo! Groups Sponsor
> >
> >
> > Get unlimited calls to
> >
> > U.S./Canada
> >
> >
> >
> > ________________________________
> > Yahoo! Groups Links
> >
> > To visit your group on the web, go to:
> > http://groups.yahoo.com/group/firebird-support/
> >
> > To unsubscribe from this group, send an email to:
> > firebird-support-unsubscribe@yahoogroups.com
> >
> > Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
>
>
>
>
> Yahoo! Groups Links
>
>
>
>
>
>
>