每个字符集有一个或多个排序规则，但每个排序规则只与一个字符集相关联。因此，以下语句会导致错误消息，因为 latin2_bin 排序规则不适用于 latin1 字符集：Each character set has one or more collations, but each collation is associated with one and only one character set. Therefore, the following statement causes an error message because the latin2_bin collation is not legal with the latin1 character set:

mysql> SELECT _latin1 'x' COLLATE latin2_bin;
ERROR 1253 (42000): COLLATION 'latin2_bin' is not valid
for CHARACTER SET 'latin1'