On Monday 23 of March 2009, Arkadiusz Miskiewicz wrote: > On Monday 23 of March 2009, Mariusz Mazur wrote: > > 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. > > So someone imported utf8 to latin1 created tables? Looks like that. mysql > does conversion on the fly, so if it has bad data or bad information about > the data it will fail if conversion is going to be applied.
s/fail/produce unexpected but totally correct result/ -- Arkadiusz Miśkiewicz PLD/Linux Team arekm / maven.pl http://ftp.pld-linux.org/ _______________________________________________ pld-devel-en mailing list pld-devel-en@lists.pld-linux.org http://lists.pld-linux.org/mailman/listinfo/pld-devel-en