Subject RE: [IBO] Incremental search trouble
Author Riho-Rene Ellermaa
Unfortunately UPPER command doesn't know how to set this string uppercase:
filiâle "Tranzîts", Buiiu n/g
All others characters are converted except "âîii".
Has anyone here from not American countries solved this problem.
I'm using Charset WIN1252


Riho-Rene Ellermaa
senior programmer
Hansabank

>
> Riho-Rene,
>
> you need to add an uppercase equivalent of the column you wish to
> incrementally search on. If the table is small then it can be just a
> computed column. If the table is large then I use triggers to
> maintain a
> real () upper case equivalent) column and create an index for it.
>
> Then, in your ColumnAttributes designate the mixed case column as Case
> Insensitive and name the uppercase equivalent column.
>
> Then incremental searching will work like a charm :-)
>
> HTH,
>
> Brian