utf8_general_ci:哪些字符相等? [英] utf8_general_ci: which characters are equal?
问题描述
在哪里可以找到WHERE
子句中相同的字符集列表?
Where do I find a list of character sets that are equal in the WHERE
clause?
背景:字符列表可用于解决另一个问题中提到的问题.
Background: The list of characters may be used to solve a problem mentioned in another question.
(也很有趣,但对于回答不是必需的:此排序规则是否永久固定,还是将来会发生变化?)
(Also interesting, but not necessary for an answer: Is this collation fixed forever, or are future changes expected?)
推荐答案
I have found this tables: http://developer.mimer.com/collations/charts/index.tml. They are, of course, landuage dependant. Collation is just comapring algorithm. For general utf8 I am not sure, how it treats special characters.
其他资源:
http://collation-charts.org/
http://mysql.rjweb.org/doc.php/charcoll (在页面上
,当然还有 http://dev.mysql .com/doc/refman/5.5/en/charset-unicode-sets.html
基本上,尝试使用Google排序规则算法mysql utf8_general_ci"或类似的方法
Basicly, try to google "collation algorithm mysql utf8_general_ci" or something like this
这篇关于utf8_general_ci:哪些字符相等?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!