Summary of the differences between collation Utf8_unicode_ci and Utf8_general_ci in MySQL
After such a long time, found that they do not know Utf_bin and utf_general_ci the difference between the two exactly.
CI is case insensitive, that is, "casing is not sensitive", a and a will be in the character judgment will be treated as the same;
The bin is binary, and a and a are treated differently.
For example you run:
SELECT * FROM table WHERE txt = ' a '
Then in Utf8_bin you can't find the line of txt = ' a ', and utf8_general_ci can.
Utf8_general_ci is not case-sensitive, you should use this when registering your username and mailbox.
Utf8_general_cs case-sensitive, if the user name and mailbox Use this will be bad consequences
Utf8_bin: String Each string is compiled with binary data stored. Case-sensitive and binary content can be stored
Summary of the differences between collation Utf8_unicode_ci and Utf8_general_ci in MySQL