Question: what is the difference between utf8_bin and utf8_general_ci?
Answer: The utf8_bin collation compares strings based purely on their Unicode code point values. ... utf8_general_ci applies Unicode normalization using language-specific rules and compares strings case-insensitively.