Am Mon, 11 Oct 2004 15:11:31 +0200 hat Nikolai Neumayer neum@ai.wu-wien.ac.at geschrieben:
Hello,
I'm running a German wiki configured using latin1. Trying to use unicode instead of latin1, all special characters like ÄÖÜ etc. are broken in the browser (and also in the database, if I take a look into the tables via phpmyadmin). This effect can be undone by running the setup again configuring latin1. Not being a specialist in such things it seems to me to
You just make a dump of your database like
$ man mysqldump $ mysqldump -u user -p --add-drop-tables database $ cp database.sql database.sql.backup
Then run that database.sql file through a converter. I use recode and it's pretty powerful. If you use debian it's just an
$ apt-get install recode
$ man recode $ recode -l $ recode l1..u8 database.sql
This should be fine normaly. Then load it back into the database.
$ man mysql $ mysql -u user -p database < database.sql
In any case make sure you read the according manpages before you use the commands to get the syntax right. I often make mistakes :-)
Of course you can use phpmyadmin for the dumping and loading but I think it's a bit long-winded for this task.
Unix is cool :-)
--tic
PS: Greetings to the city I was born in :-)
be more "modern" to use unicode. Is this correct, or should I just leave latin1. If it would make sense to convert to unicode, how can I do this? What are the consequences of using the one or the other?
Sorry for this questions of one mainly just beeing a "user" but who also does some things on a server. Any hint, even in the form of hyperlinks to further reading would be appreciated.
Nikolai
MediaWiki-l mailing list MediaWiki-l@Wikimedia.org http://mail.wikipedia.org/mailman/listinfo/mediawiki-l