Subject Re: [IBO] FW: Uppercase
Author Helen Borrie
At 02:21 PM 04-04-01 +0200, you wrote:

> -----Oorspronkelijk bericht-----
>Van: Rik [mailto:rik@...]
>Verzonden: dinsdag 27 maart 2001 8:28
>Aan: ''
>Onderwerp: Uppercase
>My customer can enter upper and lowercase characters in a field. When I
>order and search in that field IBO sorts this field : first the uppercase
>and then the lowercase and so he can't search right.
>I flagged already the 'case insensitive' in the columnattributes.
>What do I wrong ?

There is more to it than this. You need to define an indexed uppercase "proxy" column in your table to store the uppercase form of the values from the column on which you wish to have a case-insensitive search. Enter the name of this proxy column in the associated field of the CASE INSENSITIVE ColumnAttribute (this field is labelled "Upper Case Equivalent".

Populate this database column automatically by firing BEFORE INSERT and BEFORE UPDATE triggers.


All for Open and Open for All
InterBase Developer Initiative ยท