From MythTV

Hi,http://www.mythtv.org/wiki/index.php?title=Talk:Utf8_Text_in_OSD&action=edit

I just followed all your howto and it works perfectly here.

Edit: (script doesn't work, REMOVED) But, I didn't try to modify everything manually, I wrote a little php script to do the hard work.

However, it was necessary to add 'collate utf8_unicode_ci' to each line including 'character set utf8' in the dump, as I use utf8_unicode_ci and not utf8_general_ci.

=

Great work, but the HOWTO is not quite complete. Where it has:

  (command to truncate table here)

It should have something like:

  mysql> DROP DATABASE mythconverg;

And where it has:

  (command to upload modified sql file here)

It should have something like:

  mysql> CREATE DATABASE mythconverg;
  mysql> ALTER DATABASE `mythconverg` DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
  mysql> \q
  $ mysql -u root -p mythconverg < mythconverg.sql

Also note that I had to reduce the size of storagegroup.dirname when using this HOWTO with a recent SVN (9 Jul 2007).