[horde] switching to UTF8 database

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


Sveiki,

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,
 Vilius



More information about the horde mailing list