Am Mon, 11 Oct 2004 15:11:31 +0200 hat Nikolai Neumayer
<neum(a)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(a)Wikimedia.org
http://mail.wikipedia.org/mailman/listinfo/mediawiki-l