什么是二进制字符集？ [英] What is binary character set?

问题描述

我想知道什么是二进制字符集，以及与ISO / IEC 8859-1 aka Latin-1字符集有什么区别？

I'm wondering what binary character set is and what is a difference from, let's say, ISO/IEC 8859-1 aka Latin-1 character set?

推荐答案

在MySQL文档中有一个页面，其中包含 _bin和二进制排序。

There's a page in the MySQL documentation about The _bin and binary Collations.

非二进制字符串（存储在CHAR，VARCHAR和TEXT数据类型）具有字符集和排序规则。给定字符集可以具有多个排序规则，每个排序规则定义集合中的字符的特定排序和比较顺序。其中之一是字符集的二进制排序规则，由排序规则名称中的_bin后缀指示。例如，latin1和utf8具有名为latin1_bin和utf8_bin的二进制排序规则。

Nonbinary strings (as stored in the CHAR, VARCHAR, and TEXT data types) have a character set and collation. A given character set can have several collations, each of which defines a particular sorting and comparison order for the characters in the set. One of these is the binary collation for the character set, indicated by a _bin suffix in the collation name. For example, latin1 and utf8 have binary collations named latin1_bin and utf8_bin.

二进制字符串（存储在BINARY，VARBINARY和BLOB数据类型中）在非二进制字符串意义上没有字符集或排序规则。 （应用于二进制字符串，CHARSET（）和COLLATION（）函数都返回二进制值。）二进制字符串是字节序列，这些字节的数值决定排序顺序。

Binary strings (as stored in the BINARY, VARBINARY, and BLOB data types) have no character set or collation in the sense that nonbinary strings do. (Applied to a binary string, the CHARSET() and COLLATION() functions both return a value of binary.) Binary strings are sequences of bytes and the numeric values of those bytes determine sort order.

等等。也许更有意义？如果没有，我建议在文档中进一步查看有关这些事情的描述。如果是一个概念，应该解释。通常为：）

And so on. Maybe gives more sense? If not, I'd recommend looking further in the documentation for descriptions about these things. If it's a concept, it should be explained. Usually is :)

这篇关于什么是二进制字符集？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！