How can I see what character set my MediaWiki's mysql database is using?
The following tip from http://www.mediawiki.org/wiki/Manual:Backing_up_a_wiki#Character_set did not work for me:
"You can see which character set your tables are using with a statement like SHOW CREATE TABLE text. The last line will include a DEFAULT CHARSET clause."
Here's my attempt to do that:
--------------------------------------------------
[roger@cpanel68 ~]$ mysql -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 5295221 Server version: 5.0.45-community-log MySQL Community Edition (GPL)
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> SHOW CREATE TABLE text -> ---------------------------------------------------
I know little about mysql. Do you see what I did wrong?
I'm worried that my database might be in character set "latin1" and that mysqldump may corrupt my backup database by auto-converting it to "UTF-8". I don't know what character set the database actually is in and don't want to mess it up setting it to "latin1" if it is not already that.
How can I check the character set of my MediaWiki's mysql database (it is on a Redhat Linux server)?
Thanks! Roger * MediaWiki: 1.9.2 * PHP: 5.2.6 (cgi) * MySQL: 5.0.45-community-log