CODEWITHSUNDEEP
pythongoogle-app-enginesqlalchemymysql-pythongoogle-cloud-sql
user3832427
user3832427

Reputation: 23

SQLAlchemy 'character_set_name' error in GAE

After deploying application to Google App Engine this warning is raised on (what it seems like) random requests.

/sqlalchemy/dialects/mysql/base.py:2452: SAWarning: No 'character_set_name' can be detected with this MySQL-Python version; please upgrade to a recent version of MySQL-Python.  Assuming latin1.

The sql server is Google Cloud SQL.

Is there a way to fix it (maybe set character_set_name to some value) or it is totally dependent on the MySQL-Python version shipped with App Engine?

Upvotes: 2

Views: 255

Answers (1)

Gerardo Capiel
Gerardo Capiel

Reputation: 41

I got this issue if I used:

create_engine('mysql+gaerdbms:///xxx?instance=xxx:xxx')

but, it goes away if you use:

create_engine('mysql://[email protected]:3306/xxx?unix_socket=/cloudsql/xxx:xxx')

Upvotes: 1

Related Questions