character-encoding - 什么是二进制字符集？

Question

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

Answer 1

MySQL 文档中有一个关于 The _bin and binary Collations 的页面.

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 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.

等等。也许更有意义？如果没有，我建议您在文档中进一步查看有关这些内容的描述。如果是概念，就应该解释一下。通常是:)