mysql字段大小写敏感_MySQL中的大小写敏感整理

最新推荐文章于 2024-03-13 10:01:34 发布

关然

最新推荐文章于 2024-03-13 10:01:34 发布

阅读量152

点赞数

文章标签： mysql字段大小写敏感

本文链接：https://blog.csdn.net/weixin_36064575/article/details/113211147

版权

Is there any Collation type in MySQL which supports Case Sensitive.

I had all type of collation in MySQL they all have _ci at the end of their name so they are case Insensitive collation. Thank you in advance.

解决方案

According to MySQL Manual http://dev.mysql.com/doc/refman/5.0/en/charset-mysql.html you should be able to set collation to _cs for case sensitivity. You can get a list of _cs collations by executing SHOW COLLATION WHERE COLLATION LIKE "%_cs" query

After a little research:

Apparently there are no utf8_*_cs in MySQL (yet). If you need case sensitive collation for utf8 fields, you should use utf8_bin. This will mess up ORDER BY, but this can be fixed by ORDER BY column COLLATE utf8_general_ci