CREATE TABLE t (
 c LONGTEXT COLLATE utf8mb4_swedish_ci
);
INSERT INTO t (c) VALUES ('A'),('Z'),('B'),('Y');
SELECT * FROM t ORDER BY c ASC;