Subject Re: [IBO] Incremental search trouble
Author Luiz Alves
To portuguese(Brazil), I have used Charset WIN1252 and collate pxw_intl850
and works well for my needs.


----- Original Message -----
From: Riho-Rene Ellermaa <r.ellermaa@...>
To: <>
Sent: Thursday, April 05, 2001 8:06 AM
Subject: RE: [IBO] Incremental search trouble

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

> 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