EVOLUTION-MANAGER

Edit File: fulltext_charset_utf8mb4.result

DROP TABLE IF EXISTS diaries; SET NAMES utf8mb4; CREATE TABLE diaries ( id INT PRIMARY KEY, title VARCHAR(255) CHARSET utf8mb4 COLLATE utf8mb4_general_ci, content TEXT CHARSET utf8mb4 COLLATE utf8mb4_general_ci, FULLTEXT INDEX (content) ) DEFAULT CHARSET utf8mb4; INSERT INTO diaries VALUES(1, "Alphabet", "ABCDE"); INSERT INTO diaries VALUES(2, "Mathmatics", "𝐀𝐁𝐂𝐃𝐄 | U+1D400-U+1D405"); INSERT INTO diaries VALUES(3, "ひらがな", "あいうえお"); SELECT * FROM diaries WHERE MATCH (content) AGAINST("ABCDE" IN BOOLEAN MODE); id title content 1 Alphabet ABCDE DROP TABLE diaries;