Subject | UPPER() function and ä, ü, ö... |
---|---|
Author | Fabrice Aeschbacher |
Post date | 2001-11-06T14:23:33Z |
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@...
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@...