Index: SQL/mysql/schema_8_up.sql
===================================================================
--- SQL/mysql/schema_8_up.sql	(revision 0)
+++ SQL/mysql/schema_8_up.sql	(revision 0)
@@ -0,0 +1,18 @@
+-- Convert to utf8_general_ci collate on all table columns
+ALTER TABLE albums convert to character set utf8 collate utf8_general_ci;
+ALTER TABLE comments convert to character set utf8 collate utf8_general_ci;
+ALTER TABLE contributor_album convert to character set utf8 collate utf8_general_ci;
+ALTER TABLE contributor_track convert to character set utf8 collate utf8_general_ci;
+ALTER TABLE contributors convert to character set utf8 collate utf8_general_ci;
+ALTER TABLE genre_track convert to character set utf8 collate utf8_general_ci;
+ALTER TABLE genres convert to character set utf8 collate utf8_general_ci;
+ALTER TABLE metainformation convert to character set utf8 collate utf8_general_ci;
+ALTER TABLE playlist_track convert to character set utf8 collate utf8_general_ci;
+ALTER TABLE pluginversion convert to character set utf8 collate utf8_general_ci;
+ALTER TABLE progress convert to character set utf8 collate utf8_general_ci;
+ALTER TABLE rescans convert to character set utf8 collate utf8_general_ci;
+ALTER TABLE tracks convert to character set utf8 collate utf8_general_ci;
+ALTER TABLE tracks_persistent convert to character set utf8 collate utf8_general_ci;
+ALTER TABLE unreadable_tracks convert to character set utf8 collate utf8_general_ci;
+ALTER TABLE years convert to character set utf8 collate utf8_general_ci;
+
Index: SQL/mysql/schema_8_down.sql
===================================================================
--- SQL/mysql/schema_8_down.sql	(revision 0)
+++ SQL/mysql/schema_8_down.sql	(revision 0)
@@ -0,0 +1,36 @@
+-- Convert to utf8_unicode_ci collate on all table columns
+ALTER TABLE albums convert to character set utf8 collate utf8_unicode_ci;
+ALTER TABLE comments convert to character set utf8 collate utf8_unicode_ci;
+ALTER TABLE contributor_album convert to character set utf8 collate utf8_unicode_ci;
+ALTER TABLE contributor_track convert to character set utf8 collate utf8_unicode_ci;
+ALTER TABLE contributors convert to character set utf8 collate utf8_unicode_ci;
+ALTER TABLE genre_track convert to character set utf8 collate utf8_unicode_ci;
+ALTER TABLE genres convert to character set utf8 collate utf8_unicode_ci;
+ALTER TABLE metainformation convert to character set utf8 collate utf8_unicode_ci;
+ALTER TABLE playlist_track convert to character set utf8 collate utf8_unicode_ci;
+ALTER TABLE pluginversion convert to character set utf8 collate utf8_unicode_ci;
+ALTER TABLE progress convert to character set utf8 collate utf8_unicode_ci;
+ALTER TABLE rescans convert to character set utf8 collate utf8_unicode_ci;
+ALTER TABLE tracks convert to character set utf8 collate utf8_unicode_ci;
+ALTER TABLE tracks_persistent convert to character set utf8 collate utf8_unicode_ci;
+ALTER TABLE unreadable_tracks convert to character set utf8 collate utf8_unicode_ci;
+ALTER TABLE years convert to character set utf8 collate utf8_unicode_ci;
+
+-- Alter table collate setting to utf8_general_ci on all tables
+ALTER TABLE albums collate utf8_general_ci;
+ALTER TABLE comments collate utf8_general_ci;
+ALTER TABLE contributor_album collate utf8_general_ci;
+ALTER TABLE contributor_track collate utf8_general_ci;
+ALTER TABLE contributors collate utf8_general_ci;
+ALTER TABLE genre_track collate utf8_general_ci;
+ALTER TABLE genres collate utf8_general_ci;
+ALTER TABLE metainformation collate utf8_general_ci;
+ALTER TABLE playlist_track collate utf8_general_ci;
+ALTER TABLE pluginversion collate utf8_general_ci;
+ALTER TABLE progress collate utf8_general_ci;
+ALTER TABLE rescans collate utf8_general_ci;
+ALTER TABLE tracks collate utf8_general_ci;
+ALTER TABLE tracks_persistent collate utf8_general_ci;
+ALTER TABLE unreadable_tracks collate utf8_general_ci;
+ALTER TABLE years collate utf8_general_ci;
+