Problems with special characters

nyk · #1 21st December 2005, 04:58 PM

I use FC4 as a server. People can enter text in forms, that are being served by zope as UTF-8. It works, but special characters, like the german Umlaute (a,o,u with points on them) don't work. The special characters are broken when imported in mySQL from the form (my.conf is set to UTF-8). They are also broken when sent as email by a python script. The "env" reports LANG=en_US.UTF-8. But I live in europe. Is this setting the problem? Where can this be changed?

tw56 · #2 21st December 2005, 06:47 PM

Don't know if it is the same problem but I was having a problem with the same characters after I installed mod_security. I changed a setting in it and the problem went away. I guess I need to know how to allow certain german characters to be entered via ALT 0000 code and not other characters. Anyone have any advise on that.

nyk · #3 21st December 2005, 11:25 PM

I don't think my problem is related to an apache module, if you suggest this....

tw56 · #4 22nd December 2005, 03:13 PM

Do you have mod_security installed ? I had no problems with the german characters before installing mod_security and then had to change the setting SecFilterCheckUnicodeEncoding to Off. After changing that setting I was able to use the German characters again. Not an ideal situation but I have not had time to investigate configuring mod_security yet. Good luck. If it does not apply to you just ignore this.