bad result: Illegal mix of collations (utf8mb4_general_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='

[unendlichkeiten]

there is a error in our lua program which I want to query a infomation in mysql. How do I resolve this problem. database configuration as follows: mysql> SHOW VARIABLES WHERE Variable_name LIKE 'character_set_%' OR Variable_name LIKE 'collation%'; +--------------------------+-----------------+ | Variable_name | Value | +--------------------------+-----------------+ | character_set_client | utf8 | | character_set_connection | utf8 | | character_set_database | utf8 | | character_set_filesystem | binary | | character_set_results | utf8 | | character_set_server | utf8 | | character_set_system | utf8 | | collation_connection | utf8_general_ci | | collation_database | utf8_general_ci | | collation_server | utf8_general_ci | +--------------------------+-----------------+ mysql>show create table test | test | CREATE TABLE test ( id bigint(20) NOT NULL AUTO_INCREMENT, name varchar(255) DEFAULT '', create_time datetime DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), ) ENGINE=InnoDB AUTO_INCREMENT=1083742 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT |