Restore script mythconverg_restore.pl selects incorrect collation

[dennismccloud@…]

When used for a full restore of a Myth database that was originally created using Fedora instructions with character set latin1 with collation latin1_swedish_ci results in errors creating temporary tables for mythfilldatabase and unsuccessful schedule download.

The mythconverg_restore.pl script sets default collate to latin1_general_ci which results in the following error from mythfilldatabase creating temporary table in the database to build the schedule:

QMYSQL3: Unable to execute query Database error was: Illegal mix of collations (latin1_general_ci,IMPLICIT) and (latin1_swedish_ci,IMPLICIT) for operation '='

The fix was to change the database default collate back to latin1_swedish_ci with:

mysql> alter database mythconverg default character set latin1 default collate latin1_swedish_ci

[stuartm]

The default collation for 0.22+ should be utf8.

Can you tell us which version you are using?

[sphery]

(In [26856]) Fixes #9108. Don't assume that a DB upgrade will occur after a database is restored with --drop_database --create_database. This updates the DB default character set and collation after replacing an existing database rather than relying on the TV schema DB upgrade to do so.

[sphery]

(In [26857]) Refs #9108. Update the DB default character set and collation after replacing an existing database. Backports [26856] from trunk.

[sphery]

(In [26859]) Refs #9108. Actually change the pre-0.22 collation, which I forgot to do in [26856].

[sphery]

(In [26860]) Refs #9108. Change the pre-0.22 collation. Backports [26859] from trunk.