[horde] switching to UTF8 database
Andrew Morgan
morgan at orst.edu
Tue Feb 7 18:17:28 UTC 2012
On Tue, 7 Feb 2012, Vilius Šumskas wrote:
> 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?
I searched via Google but nothing obvious turned up. If you have a
timeframe and a listname, I'd be happy to go search the archives.
Andy
More information about the horde
mailing list