Hi,

I'm converting a database from SqlAnywhere to Firebird (1.5), and
have pumped the data across using Clever Components datapump.

The data contains accented characters, and the table is defined as:

CREATE TABLE PATIENTEN (
blah blah blah ....
FAMILIENAAM VARCHAR(40) CHARACTER SET WIN1252
);

The data in this field is for example "Dogné", and I want it in
upper case.

update isa_patienten set familienaam = upper(familienaam);

results in "DOGNé". Why don't I get "DOGNÉ" ?

regards, Colin