Difference between revisions of "Talk:Wiki maintenance plan"
From Apache OpenOffice Wiki
JanIversen (Talk | contribs) (Created page with "Planned wiki") |
JanIversen (Talk | contribs) m (JanIversen moved page Talk/Wiki maintenance plan to Talk:Wiki maintenance plan without leaving a redirect) |
||
(15 intermediate revisions by 3 users not shown) | |||
Line 1: | Line 1: | ||
− | + | UPDATE table_name SET col_name = CONVERT(CONVERT(CONVERT(col_name USING latin1) USING binary) USING utf8); | |
+ | :: | ||
+ | Another way to do this (and possibly a more effective solution since it can be done during the MWiki upgrade) is: | ||
+ | mysqldump -h DB_HOST -u DB_USER -p DB_PASSWORD --opt --quote-names --skip-set-charset --default-character-set=latin1 DB_NAME > DB_NAME-dump.sql | ||
+ | mysql -h DB_HOST -u DB_USER -p DB_PASSWORD --default-character-set=utf8 DB_NAME < DB_NAME-dump.sql | ||
+ | :: (source: http://blog.hno3.org/2010/04/22/fixing-double-encoded-utf-8-data-in-mysql/ ) |
Latest revision as of 19:39, 25 December 2012
UPDATE table_name SET col_name = CONVERT(CONVERT(CONVERT(col_name USING latin1) USING binary) USING utf8);
Another way to do this (and possibly a more effective solution since it can be done during the MWiki upgrade) is:
mysqldump -h DB_HOST -u DB_USER -p DB_PASSWORD --opt --quote-names --skip-set-charset --default-character-set=latin1 DB_NAME > DB_NAME-dump.sql mysql -h DB_HOST -u DB_USER -p DB_PASSWORD --default-character-set=utf8 DB_NAME < DB_NAME-dump.sql