https://bugzilla.wikimedia.org/show_bug.cgi?id=19085





--- Comment #2 from Karsten Hiddemann <[email protected]>  
2009-06-05 09:23:30 UTC ---
I've fixed this now by running the following SQL query on the wikidb:

ALTER TABLE `smw_atts2` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `smw_conc2` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `smw_conccache` CONVERT TO CHARACTER SET utf8 COLLATE
utf8_general_ci;
ALTER TABLE `smw_ids` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `smw_inst2` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `smw_redi2` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `smw_rels2` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `smw_spec2` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `smw_subs2` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `smw_text2` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;

Two more tables named `hitcounter`and `searchindex` had the same wrong
collation, I don't know if they're related to SMW.


-- 
Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are on the CC list for the bug.

_______________________________________________
Wikibugs-l mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l

Reply via email to