Hi Antti!

I think there are two different ways to get case insensitive sorting,
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 uppercase
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 sort
> differentiates upper- and lowercase characters which, while technicaly
> 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