To portuguese(Brazil), I have used Charset WIN1252 and collate pxw_intl850
and works well for my needs.

Luiz.

----- Original Message -----
From: Riho-Rene Ellermaa <r.ellermaa@...>
To: <IBObjects@yahoogroups.com>
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
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