[sqlalchemy] Strange issue with unicode

2014-07-23 Thread Andrew Pashkin
Hi all! I have an issue with unicode and SQLAlchemy. I've created topic on SO: http://stackoverflow.com/questions/24795444/how-to-save-unicode-with-sqlalchemy And repository with Vagrant/Ansible setup, so you can easily reproduce this bug on your local machine:

Re: [sqlalchemy] Strange issue with unicode

2014-07-23 Thread Michael Bayer
On Jul 23, 2014, at 1:20 PM, Andrew Pashkin andrew.pash...@gmx.co.uk wrote: Hi all! I have an issue with unicode and SQLAlchemy. I've created topic on SO: http://stackoverflow.com/questions/24795444/how-to-save-unicode-with-sqlalchemy And repository with Vagrant/Ansible setup, so you

Re: [sqlalchemy] Strange issue with unicode

2014-07-23 Thread Gunnlaugur Thor Briem
I've posted the answer on StackOverflow. You have client_encoding = sql_ascii in your postgresql.conf, and you just need to change that to utf8 or override it in your create_engine call. Cheers, Gulli On Wed, Jul 23, 2014 at 6:59 PM, Michael Bayer mike...@zzzcomputing.com wrote: On Jul 23,