id,summary,reporter,owner,description,type,status,priority,milestone,component,version,severity,resolution,keywords,cc,mlocked 5051,Cannot create new database SVN Revsion 16814,harpax,Janne Grunau,"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:[[BR]] mysql> show variables like ""character_set_database"";[[BR]] character_set_database latin1[[BR]] Database character set after running mythtv-setup:[[BR]] mysql> show variables like ""character_set_database"";[[BR]] character_set_database utf8[[BR]] ",defect,closed,minor,0.22,mythtv,head,medium,fixed,,,0