Subject Re: [IBO] Case-insensitive sorting
Author mspencewasunavailable
--- In, Svein Erling Tysvaer
<svein.erling.tysvaer@...> wrote:
> Hi Antti!
> I think there are two different ways to get case insensitive
> one is to use a case insensitive character set (or maybe it is
> collation?), the other is to add another column that should
contain the
> uppercase equivalent of your column, populate this column through
> insert/update triggers and then specify this field as the
> equivalent of your mixed case field and then IBO does the rest
> (unfortunately, I don't remember the name of the property, but it
is one
> simple property relating to the field in your TIB_Query).
> HTH,
> Set
> Antti Kurenniemi wrote:
> > Hi all,
> >
> > I'm (once again) probably missing something quite obvious, but
how can I
> > make IBO grids sort case-insensitive? It seems that the default
> > differentiates upper- and lowercase characters which, while
> > accurate, is not what I want. It also makes the searches
(including Locate)
> > work wrong. For example, a column with the following values:
> >
> > Kalavale
> > KOS - Kouhian Outo Seurue
> > Kopiotoimi Tampereella
> >
> > will never find the "Kopiotoimi" value because it stops
on "KOS", and this
> > is a bit bonkers (for the users). Any help appreciated.
> >
> >
> > TIA,
> > Antti Kurenniemi

Adding ORDER BY UPPER(<fieldname>) to the TIB_QUERY works fine for
me when used with a grid. Is there some reason you can't do this?
(Don't know whether this'd work with a search, but I'd bet there's a

Michael D. Spence
Mockingbird Data Systems, Inc.