Subject UPPER() function and ä, ü, ö...
Author Fabrice Aeschbacher
Hi,

I use triggers to maintain some columns uppercase:

new.last_name = upper( new.last_name );

The problem is, some characters are not uppercased, particularly the
ä, ü, ö. For example:

müller => MüLLER (sould be: MÜLLER)

I have already tried with character sets NONE, ISO8859_1 or WIN1252,
without success.

Has anyone an idea how to solve this?

(Firebird 1.0.0Beta2 / windows)

Regards,
Fabrice
mailto:fabrice.aeschbacher@...