Fix XV Random Quotes table collation

gistfile1.txt

use wordpress;

show full columns from wp_stray_quotes;

alter table wp_stray_quotes change quote quote VARCHAR(100) character set latin1;
alter table wp_stray_quotes change quote quote VARBINARY(100);
alter table wp_stray_quotes change quote quote VARCHAR(100) character set utf8mb4 COLLATE utf8mb4_unicode_ci;


alter table wp_stray_quotes change author author VARCHAR(100) character set latin1;
alter table wp_stray_quotes change author author VARBINARY(100);
alter table wp_stray_quotes change author author VARCHAR(100) character set utf8mb4 COLLATE utf8mb4_unicode_ci;


alter table wp_stray_quotes change `source` `source` VARCHAR(100) character set latin1;
alter table wp_stray_quotes change `source` `source` VARBINARY(100);
alter table wp_stray_quotes change `source` `source` VARCHAR(100) character set utf8mb4 COLLATE utf8mb4_unicode_ci;


alter table wp_stray_quotes change category category VARCHAR(100) character set latin1;
alter table wp_stray_quotes change category category VARBINARY(100);
alter table wp_stray_quotes change category category VARCHAR(100) character set utf8mb4 COLLATE utf8mb4_unicode_ci;


alter table wp_stray_quotes change visible visible VARCHAR(100) character set latin1;
alter table wp_stray_quotes change visible visible VARBINARY(100);
alter table wp_stray_quotes change visible visible VARCHAR(100) character set utf8mb4 COLLATE utf8mb4_unicode_ci;


alter table wp_stray_quotes change user user VARCHAR(100) character set latin1;
alter table wp_stray_quotes change user user VARBINARY(100);
alter table wp_stray_quotes change user user VARCHAR(100) character set utf8mb4 COLLATE utf8mb4_unicode_ci;

ALTER TABLE wp_stray_quotes CHARACTER SET utf8mb4;