Using sqlalchemy and mysql-python， how to set charset=utf8mb4?

Question

engine = create_engine('mysql+mysqldb://root:123456@localhost:3306/tianchi?charset=utf8mb4')

Traceback:

sqlalchemy.exc.OperationalError: (_mysql_exceptions.OperationalError) (2019, "Can't initialize character set utf8mb4 (path: C:\mysql\\share\charsets\)")

sqlalchemy:1.2.7 Mysql-python:1.2.5 Mysql:5.7.13

@KKK I don't know "utf8mb4” file name, and 'set names utf8mb4' works in MySQL client. — hyjal
– hyjal, Commented May 15, 2018 at 0:55
@Daniel E. I copyed "..\share\charsets\" to "C:\mysql\\share\charsets\",but it didn't work — hyjal
– hyjal, Commented May 15, 2018 at 0:57

hyjal · Accepted Answer · 2018-05-15 05:20:36Z

2

I replace 'mysqldb' with 'pymysql' and it works.Thank everyone.

answered May 15, 2018 at 5:20

hyjal

638 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Ben Over a year ago

Thank you, thank you, thank you! For me, the change was FROM: mysql+mysqlconnector TO mysql+pymysql

Collectives™ on Stack Overflow

Using sqlalchemy and mysql-python， how to set charset=utf8mb4?

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related