@@ -, +, @@ --- installer/data/mysql/updatedatabase.pl | 6 +++--- 1 file changed, 3 insertions(+), 3 deletions(-) --- a/installer/data/mysql/updatedatabase.pl +++ a/installer/data/mysql/updatedatabase.pl @@ -11286,11 +11286,11 @@ if ( CheckVersion($DBversion) ) { CREATE TABLE audio_alerts ( id int(11) NOT NULL AUTO_INCREMENT, precedence smallint(5) unsigned NOT NULL, - selector varchar(255) NOT NULL, - sound varchar(255) NOT NULL, + selector varchar(255) COLLATE utf8_unicode_ci NOT NULL, + sound varchar(255) COLLATE utf8_unicode_ci NOT NULL, PRIMARY KEY (id), KEY precedence (precedence) - ) ENGINE=InnoDB DEFAULT CHARSET=utf8; + ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; }); $dbh->do(q{ --