Upgrading to 2.11 - SQL alter table

Alan Munday amavis45 at brightheadtechnology.com
Wed Jun 29 23:36:42 CEST 2016

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 

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



More information about the amavis-users mailing list