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