MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE `players` (
  `id` bigint UNSIGNED NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
ALTER TABLE `players`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `players_name_unique` (`name`);

Records: 0  Duplicates: 0  Warnings: 0


insert into players values (1, '𝓜𝓤𝓡𝓓𝓐𝓗'), (2, 'jim')

Records: 2  Duplicates: 0  Warnings: 0


select * from players where `name` = '🅲🅷🅰🆁🅾🅽'


id
name


1
𝓜𝓤𝓡𝓓𝓐𝓗