Bug 155448 – [bugstest, revisit] utf8 incorrectly imported from dump

• Status: RESOLVED FIXED
• Product: Gentoo Infrastructure

[Description Dan 2006-11-16 20:56:32 UTC]

Them crazy people using UTF-8...

see bug 154756 comment 2 (or any one of the other bugs flameeyes has commented on) for an example

[Comment 1 Petteri Räty (RETIRED) 2006-11-21 01:44:10 UTC]

Yep. Same with my name. 
http://bugstest.gentoo.org/show_bug.cgi?id=113389

[Comment 2 Robin Johnson 2006-11-22 04:08:28 UTC]

Ok, it's actually that the old data was not correctly imported.
If you enter new data, or change your displayed name, it is treated correctly.
I'll trace the source of the import corruption in a bit.

[Comment 3 Bo Ørsted Andresen (RETIRED) 2006-11-22 07:52:29 UTC]

(In reply to comment #2)
> Ok, it's actually that the old data was not correctly imported.
> If you enter new data, or change your displayed name, it is treated correctly.
> I'll trace the source of the import corruption in a bit.

Yes, changing my name at http://bugstest.gentoo.org/userprefs.cgi fixes it.

[Comment 4 Robin Johnson 2006-12-24 04:26:39 UTC]

Note to self:
when exporting use:
mysqldump --opt --hex-blob --set-charset --default-character-set=utf8  --skip-extended-insert
dump structure first, and then data.

[Comment 5 Piotr Jaroszyński (RETIRED) 2006-12-24 05:34:07 UTC]

Actually bugs.gentoo.org doesn't support UTF-8, afair it's just ISO 8859-1. Although I am happy to see that bugstest does support UTF-8 and I can put my name right(bug #135029#c4) ;]

[Comment 6 Robin Johnson 2007-01-06 05:53:08 UTC]

properly resolved now, mysql was at fault during the import.
(this is me testing bugzilla).