[SOGo] migrating sogo (db) to utf8mb4

[goetz.reini...@filmakademie.de]

Hello all,

What is the most practicable way to migrate an utf8 sogo db environment to 
utf8mb4?

Is adding „MySQL4Encoding = „utf8mb4“ to sogo.conf and running the following on 
the DB server enough? Doing a DB backup dump first. ;)

ALTER DATABASE sogo_DB CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE  sogo_DB.* CONVERT TO CHARACTER SET utf8mb4 COLLATE 
utf8mb4_unicode_ci;

        Thanks for hints and suggestions . Regards . Götz

smime.p7s
Description: S/MIME cryptographic signature