I create sqlalchemy engine connecting to MySQL database. I want to specify charset as create_engine argument.
If I use create_engine liKe that:
create_engine('mysql+mysqldb://pd:pd@localhost/pd?charset=utf8')
then all is fine. But, when I use it like that:
create_engine('mysql+mysqldb://pd:pd@localhost/pd', charset='utf8')
then I get the following error:
TypeError: Invalid argument(s) 'charset' sent to create_engine(), using
configuration MySQLDialect_mysqldb/QueuePool/Engine. Please check that
the keyword arguments are appropriate for this combination of components.
According to the documentation, this usage should be possible:
The string form of the URL is
dialect+driver://user:password@host/dbname[?key=value..] ...
**kwargs takes