I've been playing with my new LuxCal calendar and tried to import an ics file that had emoji in it. Oops, the db is utf8, so I needed to convert it to utf8mb4 to support emoji.
I ran this in the SQL box in phpMyAdmin on the db:
SET collation_connection = 'utf8mb4_unicode_ci';
ALTER DATABASE radioshack_luxcal CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE mycal_categories CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE mycal_events CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE mycal_groups CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE mycal_settings CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE mycal_styles CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE mycal_users CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
And then added this to the [mysqld] section in /etc/my.cnf
collation-server = utf8mb4_unicode_ci
init-connect='SET NAMES utf8mb4'
character-set-server = utf8mb4
Restarted MySQL and the ics file imported with emojis! And now I can add emoji to calendar events, which is cute.