change database collation:
ALTER DATABASE <database_name> CHARACTER SET utf8 COLLATE utf8_unicode_ci;
change table collation:
ALTER TABLE <table_name> CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
change column collation:
ALTER TABLE <table_name> MODIFY <column_name> VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci;
©
stackoverflow.com/questions/5906585/how-to-change-..._ci
после
COLLATE
- значит case insensetive
Можно также применять особые правила сравнения к отдельным запросам:
SELECT k
FROM t1
ORDER BY k COLLATE latin1_german2_ci;
dev.mysql.com/doc/refman/5.7/en/charset-collate.html