MySQL Forums
Forum List  »  Connector/Python

8.0.17 bug: unknown collation utf8mb4_0900_ai_ci
Posted by: 逊 钟
Date: July 30, 2019 09:40PM

Hi,
We are using Flask with SqlAlchemy, and mysql-connector-python is part of the dependency, we noticed the latest release rendered our service broken.
We did not specify the db connector version (a bad practice I know), so the recent deployment installed 8.0.17, then we tried to insert an emoji character into db which caused an error: sqlalchemy.exc.DatabaseError: (mysql.connector.errors.DatabaseError) 1273 (HY000): Unknown collation: 'utf8mb4_0900_ai_ci'.
As soon as we installed 8.0.16 manually, we are able to do so without a scratch.
So I was wodering if mysql-connector-python 8.0.17 is not respecting the fact that we have a 5.7.26 version mysql and use the default collation for mysql 8.0 to talk to mysql server?

Cheers.

Victor Z

Options: ReplyQuote


Subject
Written By
Posted
8.0.17 bug: unknown collation utf8mb4_0900_ai_ci
July 30, 2019 09:40PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.