[imp] horde utf8 problem

[Nico Färber]

Hi,

@Jan  Thank you for your answer.

Yes, upgrading would be the correct way but
unfortunately we cannot upgrade horde at the moment but we will do later.
Nevertheless I would like to find a workaround to have proper umlauts  
in horde.

Any hints?

Cheers Nico


Quoting Jan Schneider <jan at horde.org>:

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