[horde] Horde and UTF

[Vilius Sumskas]

Hi again,

Cituojama Jan Schneider <jan at horde.org>:

> Zitat von Vilius Sumskas <vilius at lnk.lt>:
>
> > I noticed that by default all data on new machine is stored in UTF-8
> > in mysql.
> > But on old one in iso-8859-13. I tried setting
> > $conf['sql']['charset'] to iso-
> > 8859-13, but it seems that horde ignores it. Is there any way to turn off
> UTF
>
> This is not true. Where this happens, it is a bug. But as you didn't tell us
> with which data that happens, I can't give you a better answer.

I made some research and this is what i found. It seems that Nag, Kronolith,
Mnemo and other lists is stored in UTF-8. While `actual` data such as mnemo
text or name is stored in my desired iso-8859-13.


----------------
--- horde/conf.php

$conf['sql']['phptype'] = 'mysql';
$conf['sql']['persistant'] = false;
$conf['sql']['socket'] = '/var/lib/mysql/mysql.sock';
$conf['sql']['protocol'] = 'unix';
$conf['sql']['hostspec'] = 'localhost';
$conf['sql']['database'] = 'horde';
$conf['sql']['charset'] = 'iso-8859-13';



--- horde/nls.php

$nls['defaults']['language'] = 'lt_LT';
$nls['defaults']['charset'] = 'iso-8859-13';


mysql> select attribute_value from horde_category_attributes where category_id
= 12;
+-----------------+
| attribute_value |
+-----------------+
| user0002 at lnk.lt |
| ąĨęėÄÆÅ&#65533;    |
| 30              |
+-----------------+

mysql> select * from mnemo_memos;
+-----------------+---------+-----------+-----------+---------------+-----------
---+
| memo_owner      | memo_id | memo_desc | memo_body | memo_category |
memo_private |
+-----------------+---------+-----------+-----------+---------------+-----------
---+
| user0002 at lnk.lt |       1 | ąčęėįšų   | ąčęėįšų   |             0
|            1 |
+-----------------+---------+-----------+-----------+---------------+-----------
---+

character set  cp1257  (mysql variable from phpmyadmin).
Horde and friends are from yesterday's CVS. Maybe it's a bug in DataTree
library?

---
   Vilius