大家开发中mysql数据库排序规则一般用utf8-bin还是utf-8-general-ci

Question

mysql数据库排序规则一般用utf8-bin还是utf-8-general-ci,前者大小写敏感，后者不敏感，大家的习惯一般怎么用，或者什么情况下使用2者

Answer 1

The answer to this question has been explained very clearly. You can refer to it:
https://segmentfault.com/q/1010000000132450

There is a comment below that summarizes:

Unicode solves the accuracy, mainly for German and French; but if it is in China, general is a faster choice.

Answer 2

Always use utf8-general-ci (case insensitive)