[horde] switching to UTF8 database

Andrew Morgan morgan at orst.edu
Mon Feb 6 22:34:57 UTC 2012


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';


Thanks,
 	Andy


More information about the horde mailing list