开发者

Case insensitivity for DB Collation - does it affect performance?

开发者 https://www.devze.com 2022-12-13 02:02 出处:网络
Earlier on while I was working on my databases, I wondered if using a case sensitive collation like utf8_bin would increase performance over case insensitive collaction like utf8_general_ci (examples

Earlier on while I was working on my databases, I wondered if using a case sensitive collation like utf8_bin would increase performance over case insensitive collaction like utf8_general_ci (examples are from MySQL).

Does anyone have any comment on this? What about databases oth开发者_Python百科er than MySQL?


Yes, a binary collation will be faster then others. How much, I can't say.

A binary sort or compare is simpler than dealing with case (+ accent, kanatype and width in SQL Server).

0

精彩评论

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

关注公众号