Subject | RE: [IBO] Incremental search trouble |
---|---|
Author | Riho-Rene Ellermaa |
Post date | 2001-04-05T11:06:41Z |
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
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