utf8mb3_unicode_ci

CREATE TABLE collate_example1 (
  name VARCHAR(32) CHARSET utf8,
  description VARCHAR(64) CHARSET utf8 COLLATE utf8mb3_unicode_ci
);

CREATE TABLE collate_example2 (
  name VARCHAR(32),
  description VARCHAR(64)
) DEFAULT CHARSET utf8, DEFAULT COLLATE utf8mb3_unicode_ci;

SET SESSION collation_connection = 'utf8mb3_unicode_ci';