Jabber going down

Patryk Zawadzki patrys at pld-linux.org
Mon Mar 23 15:45:40 CET 2009


2009/3/23 Mariusz Mazur <mmazur at kernel.pl>:
> Dnia poniedziałek, 23 marca 2009, Arkadiusz Miskiewicz napisał:
>> This means that your database was broken initially.  There are ways to fix
>> this if you have working old mysql setup and _then_ do dump.
> To fix it, it was enough to tell mysqldump to use utf8 instead of latin1 for
> dumping. The resulting file was perfectly normal utf8, even though the dump
> said CHARSET=latin1 on all tables. It was enough to modify those CHARSETs to
> utf8 and reimport the whole db using mysql (also set to utf8). It works fine
> now.
>
> I have no problem with it working this way, it's quite normal. The me being an
> idiot part is that I missed this functionality.

It's not normal. It's caused by broken collation settings.

-- 
Patryk Zawadzki


More information about the pld-devel-en mailing list