Upgrading to 2.11 - SQL alter table

[Alan Munday]

Fedora have recently released 2.11 for Fedora 24 and I was looking to
alter the msgs.subject msgs.from_addr fields.


Taking the values from the mySQL readme I thought the following would do
the trick:

MariaDB [amavis]> ALTER TABLE
-> msgs
-> CHANGE subject from_addr
-> VARCHAR(255)
-> CHARACTER SET utf8mb4
-> COLLATE utf8_bin
-> DEFAULT '';

ERROR 1253 (42000): COLLATION 'utf8_bin' is not valid for CHARACTER SET
'utf8mb4'


I have no SQL expertise so I could with some help here with what I've
done wrong.

Thanks

Alan