[imp] horde utf8 problem

Jan Schneider jan at horde.org
Wed Mar 28 14:36:10 UTC 2012


Zitat von Nico Färber <nicco at students.unibe.ch>:

> 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

Upgrade to Horde 4.

> 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
>
> -- 
> imp mailing list
> Frequently Asked Questions: http://wiki.horde.org/FAQ
> To unsubscribe, mail: imp-unsubscribe at lists.horde.org

-- 
The Horde Project
http://www.horde.org/




More information about the imp mailing list