I work with the MySQL table, for the entire table when creating it is specified CHARACTER SET=utf8mb4 COLLATE=utf8mb4_bin . Cyrillic is processed all successfully, except for the capital "I".

 mysql> select count(*) from bashorg where rstr="Гы"; +----------+ | count(*) | +----------+ | 1 | +----------+ 1 row in set (0,00 sec) mysql> select count(*) from bashorg where rstr="Иа"; ERROR 1267 (HY000): Illegal mix of collations (utf8mb4_bin,IMPLICIT) and (cp1251_general_ci,COERCIBLE) for operation '=' mysql> select count(*) from bashorg where rstr="И"; ERROR 1267 (HY000): Illegal mix of collations (utf8mb4_bin,IMPLICIT) and (cp1251_general_ci,COERCIBLE) for operation '='

Where does such discrimination come from in relation to one Iwi?

    1 answer 1

    It turned out that the server has the cp1251 connection encoding installed.

    To correct the error, you can either change the server configuration, or perform at the beginning of each session

     set character set utf8mb4;