[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