Hi and thank you for your reply.
I executed the query. The collation is listed as “utf8mb4_unicode_ci” on all columns of snippets table. Emoji still does not work. I restarted the database, tried a different browser. Still, emoji disappears, when I save the snippet.
I tried the second approach with only run once snippet – same result.