Mysql.connector.errors.DatabaseError: 1267 (HY000): Illegal mix of collations

개요

mysql.connector.errors.DatabaseError: 1267 (HY000): Illegal mix of collations

Traceback (most recent call last):
  File "hello.py", line 116, in <module>
    oldrow = query_row('SELECT * FROM articles WHERE name=%s AND repo_id=%s', (name, repo_id) )
  File "hello.py", line 30, in query_row
    rows = query_rows(sql,params)
  File "hello.py", line 25, in query_rows
    mycursor.execute(sql,params)
  File "/root/.local/lib/python3.8/site-packages/mysql/connector/cursor.py", line 551, in execute
    self._handle_result(self._connection.cmd_query(stmt))
  File "/root/.local/lib/python3.8/site-packages/mysql/connector/connection.py", line 490, in cmd_query
    result = self._handle_result(self._send_cmd(ServerCmd.QUERY, query))
  File "/root/.local/lib/python3.8/site-packages/mysql/connector/connection.py", line 395, in _handle_result
    raise errors.get_exception(packet)
mysql.connector.errors.DatabaseError: 1267 (HY000): Illegal mix of collations (utf8mb4_general_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='