Thanks everyone for the help. I'm finally getting somewhere.
where is this format of UPPER (with more than 1 parameter) defined?
I haven't found it in any of the IB 6.0 docs, FB 1.5 doc etc.

By the way, uppercasing Dogné with ISO8859_1 FR_FR gives DOGNE.
FR_CA, DE_DE, IT_IT etc give DOGNÉ. Why does FR_FR not comply?

regards, Colin

--- In firebird-support@yahoogroups.com, "Ivan Prenosil"
<Ivan.Prenosil@s...> wrote:

> Your table has defined collations, but the data you are

uppercasing don't. Try

>
> update the_table
> set x1 = upper('Dogné' COLLATE PXW_SPAN), ...
>
> or
>
> update the_table
> set x1 = upper(_WIN1252 'Dogné' COLLATE PXW_SPAN), ...
>
> or
>
> update the_table
> set x1 = upper(x1), ...
>
>
> Ivan
> http://www.volny.cz/iprenosil/interbase/
>
> ----- Original Message -----
> From: "colinriley666" <colin.riley@p...>
> To: <firebird-support@yahoogroups.com>
> Sent: Thursday, April 14, 2005 3:02 PM
> Subject: [firebird-support] Re: win1252 and upper()
>
>
>
>
> Hello Pavel,
>
> thank you very much for replying. I've added a few columns for

test

> purposes :
> X1 VARCHAR(50) CHARACTER SET WIN1252 COLLATE PXW_INTL,
> X2 VARCHAR(50) CHARACTER SET WIN1252 COLLATE PXW_INTL850,
> X3 VARCHAR(50) CHARACTER SET WIN1252 COLLATE PXW_NORDAN4,
> X4 VARCHAR(50) CHARACTER SET WIN1252,
> X5 VARCHAR(50) CHARACTER SET WIN1252 COLLATE PXW_SPAN,
> X6 VARCHAR(50) CHARACTER SET WIN1252 COLLATE PXW_SWEDFIN
>
> I then performed :
>
> update the_table
> set x1 = upper('Dogné'), x2 = upper('Dogné'), x3 = upper('Dogné'),
> x4 = upper('Dogné'), x5 = upper('Dogné'), x6 = upper('Dogné')
> where the_key = 36545;
>
> The 'é' is alt-0233, and looking with a hex editor = x'E9'.
>
> The results in all six of the columns is 'DOGNé'.
>
> Any further thoughts?
>
> regards, Colin