开发者

MySQL - Proper "Collation" for case-sensitive text? UTF8-bin?

开发者 https://www.devze.com 2023-04-03 22:55 出处:网络
In using 开发者_Python百科MySQL (v5.0.77) there are a lot of choices for Collation. I was originally thinking of UTF8-general_ci however MySQL shows it as being case-insensitive which I think would ca

In using 开发者_Python百科MySQL (v5.0.77) there are a lot of choices for Collation. I was originally thinking of UTF8-general_ci however MySQL shows it as being case-insensitive which I think would cause problems for objects such as passwords. If I want to use UTF8 but want case-sensitive data should I use UTF8-bin? Thanks!


Try utf8_bin.

A hint. When the colation ends with CS it means "Case Sensitive". For example: utf8_croatian_cs is Case Sensitive.

0

精彩评论

暂无评论...
验证码 换一张
取 消

关注公众号