[horde] switching to UTF8 database

Vilius Šumskas vilius at lnk.lt
Tue Feb 7 06:46:09 UTC 2012


Tuesday, February 7, 2012, 12:34:57 AM, you wrote:

> I'm running Horde v3.3.12 (I know, upgrade to Horde 4 is on my todo list)
> with MySQL v5.1.  My Horde database is an old install that has been 
> upgraded many times.

> The character set in horde/config/conf.php is:

> $conf['sql']['charset'] = 'iso-8859-1';

> and my collation on the database and tables in MySQL are set to 
> "latin1_swedish_ci".

> I'd like to switch to UTF8.  Are these steps sufficient:

> 1. Alter MySQL database and table collations to "utf8_unicode_ci"

> 2. Set $conf['sql']['charset'] = 'utf-8';

It  depends  what data is stored. See my older messages regarding that
on this mailing list. Or was it on dev at lists.horde.org?

Best regards,

More information about the horde mailing list