Cannot create new database SVN Revsion 16814

[harpax]

MythTV changes the database character set from latin1 when it is created to UTF8 while upgrading the schema, then attempts to create a primary key > 1000 bytes (128+255) bytes * 3 (for UTF8) = 1149 bytes total. The schema upgrade always fails due to the length of the key.

Procedure to reproduce:

1. Create the database with mysql -u root < mc.sql
2. run mythtv-setup

Database character set before running mythtv-setup:
mysql> show variables like "character_set_database";

character_set_database latin1

Database character set after running mythtv-setup:
mysql> show variables like "character_set_database";

character_set_database utf8

[harpax]

I wanted to include the output of mythtv-setup with the ticket, but trac keeps rejecting it as spam. It wouldn't even allow me to attach it as a text file.

[Janne Grunau]

(In [16818]) the initial database has to use latin1 as default character set. Closes #5051