Enable Emoji-Support for MySQL-Databases

oz, 2022-04-27

Copy&pastable below

-- ...
`CUSTOMER_COMMENT` varchar(1000) COLLATE utf8mb4_bin DEFAULT NULL,
-- ...
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

Convert existing table:

ALTER TABLE `CUSTOMER`
  CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;