SQLAlchemy and python - retrieving non-ascii chars from DB

Question

My question: Why can't I retrieve non-ascii chars from sqlalchemy db into python?

In more detail: I have an entry with non-ascii char in my sqlalchemy db (Umlaut for example). When I try to retrieve this entry by using:

q=self.session.query(Table_Name).filter(Table_Name.id=='some id')
q.all()

I receive the following error:

UnicodeEncodeError: 'ascii' codec can't encode characters in position

I solved it by decoding the entries into UTF-8 before inserting the entry to the DB.

Yet I wondered - why does this error appeared? Is there an option to fetch entries already encoded as unicode for example instead of bytechar\ascii into python?

Is your db UTF-8 and you have # -- coding: utf-8 -- in python too? — Amin Alaee
– Amin Alaee, Commented Jun 9, 2016 at 13:52

Sam · Accepted Answer · 2016-06-09 13:53:39Z

1

Per the docs, you should specify the encoding in the connection string:

e = create_engine("mysql+pymysql://scott:tiger@localhost/test?charset=utf8")

answered Jun 9, 2016 at 13:53

Sam

4,09023 silver badges27 bronze badges

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

Collectives™ on Stack Overflow

SQLAlchemy and python - retrieving non-ascii chars from DB

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related