I remember having had such a problem before, when migrating from 1.17 to 1.18
I made this not in our internal memeo:
30-jan-2012
We find that our wikidb is internally in latin1, and everything appears to be double encoded inside.
We arun into problems when other apps like adbedit access it.
To convert to utf8, we follow the steps in ttp://www.mediawiki.org/wiki/Manual:Backing_up_a_wiki
mysqldump -u root -pXXXXXX --opt --default-character-set=latin1 --skip-set-charset wikidb > wikidb_as80.sql
the next command is different from the instruction, we added 'i' to make it case independent. sed -e 's/character set latin1 collate latin1_bin/character set utf8 collate utf8_bin/ig' -e 's/CHARSET=latin1/CHARSET=utf8/ig' wikidb_as80.sql > wikidb_as80.sql.u8
Now the length of key strings can be too long: we do nothing for that
Then I login to mysql as root: mysql -u root -pXXXXXX mysql drop database wikidb; create database wikidb;
mysql -u root -pXXXXX --default-character-set=utf8 wikidb < wikidb_wwx.sql.u8
----- end memo note
When I run SELECT @@character_set_database, @@collation_database; now on wikidb, I get the same result as you have!
Internally, it still seems to have latin1. But I see no effects of that which cause any problems.
On 11.02.15 16:21, Marc Patermann wrote:
Hi,
Marc Patermann schrieb (02.02.2015 11:01 Uhr):
I have a little old and well used Mediawiki installation, which has to be migrated. The old installation is version 1.12.0 with php 5.1 and mysql 5.0. The new one is php 5.3.17 and mysql 5.5.31, I tried Mediawiki 1.24.1.
I got the database migrated by now.
The new situation is, that the Umlauts/die Umlaute äüö und ß in my wiki pages are broken.
The html on old an new is transfered as UTF-8: old:
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="de" lang="de" dir="ltr"> <head> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" /> new: <html lang="de" dir="ltr" class="client-nojs"> <head> <meta charset="UTF-8" /> <title>Wiki der Systembereich IuK</title> <meta name="generator" content="MediaWiki 1.24.1" />
The database is the same type too: mysql> SELECT @@character_set_database, @@collation_database; +--------------------------+----------------------+ | @@character_set_database | @@collation_database | +--------------------------+----------------------+ | latin1 | latin1_swedish_ci | +--------------------------+----------------------+ 1 row in set (0.00 sec) new: mysql> SELECT @@character_set_database, @@collation_database; +--------------------------+----------------------+ | @@character_set_database | @@collation_database | +--------------------------+----------------------+ | latin1 | latin1_swedish_ci | +--------------------------+----------------------+ 1 row in set (0.00 sec)
LC_CTYPE=de_DE.UTF-8 is set on both servers.
I switched $wgDBTableOptions with no success.
How can I correct this?
Marc
MediaWiki-l mailing list To unsubscribe, go to: https://lists.wikimedia.org/mailman/listinfo/mediawiki-l