[imp] horde utf8 problem

[Nico Färber]

Hi,

I'm using horde with mysql database. Problems occur with umlauts like
for example in personal settings "Standartidentität" appears  as  
"Standartidentität".
I want all data that i query from mysql converted to utf8 in horde.

I found some soluions on the internet but they did not work for me so far.
For example one solution suggests to add mysql_query("SET NAMES  
'utf8'") after mysql connect statement.
in PEAR::DB library. But where exactly? Does this really makes a  
conversion to utf8?

fyi:
horde version 3.3.x
mysql 5.0
mysql uses the following characterset:

mysql> SHOW VARIABLES LIKE 'character\_set\_%';
| Variable_name            | Value  |
+--------------------------+--------+
| character_set_client     | latin1 |
| character_set_connection | latin1 |
| character_set_database   | latin1 |
| character_set_filesystem | binary |
| character_set_results    | latin1 |
| character_set_server     | latin1 |
| character_set_system     | utf8   |
+--------------------------+--------+
7 rows in set (0.00 sec)

cheers Nico