Subject Re: [IBO] Case-insensitive sorting
Author Svein Erling Tysvaer
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).


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