mysql 两个字符串比较大小

SELECT * FROM table WHERE column COLLATE utf8mb4_general_ci = 'some_string';

SELECT * FROM table WHERE column COLLATE utf8mb4_bin = 'Some_String';

ALTER TABLE table_name CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

-- 创建表
CREATE TABLE users (
    id INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(255)
) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

-- 插入数据
INSERT INTO users (name) VALUES ('Alice'), ('Bob'), ('alice');

-- 搜索和排序
SELECT * FROM users WHERE name COLLATE utf8mb4_general_ci = 'alice';
SELECT * FROM users ORDER BY name COLLATE utf8mb4_general_ci;