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