Question: what is the difference between utf8_general_ci and utf8_unicode_ci?
Answer: In short: utf8_unicode_ci uses the Unicode Collation Algorithm as defined in the Unicode standards, whereas utf8_general_ci is a more simple sort order which results in "less accurate" sorting results. See the mysql manual, Unicode Character Sets section: ... It can make only one-to-one comparisons between characters.