Hello Colin,

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

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

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

c> update isa_patienten set familienaam = upper(familienaam);

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

I think you should specify the collation for your varchar field(s)
additionally. The collation "knows" how to covert "é" to "É" (but not
the default collation WIN1252). The list of available collations for
WIN1252 character set: WIN1252, PXW_INTL, PXW_INTL850, PXW_NORDAN4,
PXW_SPAN and PXW_SWEDFIN.
Probably you'd better to create domains like
-----
CREATE DOMAIN <YourDomainName> AS VARCHAR(40)
CHARACTER SET WIN1252 COLLATE <YourCollationName>;
-----
and use them for your field(s).


HTH
--
Best regards,
Pavel Menshchikov
http://www.ls-software.com