Moritz Karbach skrev:
It's shown correctly in phpMyAdmin, which displays
utf8 pages (at least all
german umlauts look well when I select utf8 in my browser). Mysqldumping this
works fine, I get an correct utf8 file. Importing this again works fine if I
select utf8 encoded file.
Our wikis are showing swedish characters correctly while they look
screwed up in phpMyAdmin.
But the wiki keeps displaying screwed umlauts, like
"ä" or "ä" instead
of "ä", depending on which encoding I chose in my browser, but no encoding
seems to work fine.
It seems like your dump has been "utf-8ified" one time too much.
"ä" is
how an ä will show if you look at an utf-8 encoded text with latin1 in
your browser. "ä" is how it will look if this "happens twice",
which
can happen sometimes when you take dumps via phpMyAdmin.
I often have to do a conversion of the dumps after downloading them
(because of the Swedish characters being screwed up). I use EditpadPro 6
(
http://www.editpadpro.com/) for the conversion. In EditPad Pro I first
choose to interpret as UTF-8 and then convert to utf-8.
I import my database dumps using the wonderful "BigDump" script (highly
recommended!
http://www.ozerov.de/bigdump.php), where I then have to
specify the charset setting to the same as my dump file, in this case
utf-8.
There seem to be many factors that can affect the charset though, so if
the above doesn't work you might have to play around a little.
For example you can try to get it look OK when the dump file is in
latin1 format, and specifying "latin1" in bigdump. This I do in Edit Pad
Pro 6 by first choosing to interpret as UTF-8, and then convert to Latin 1.
Hope this gives some help!
Regards
Samuel Lampa
--
RIL Partner AB
http://rilnet.com