[Sqlalchemy-tickets] Issue #3143: UnicodeEncodeError in StatementError (zzzeek/sqlalchemy)
Brought to you by:
zzzeek
|
From: kodemi <iss...@bi...> - 2014-07-28 10:43:03
|
New issue 3143: UnicodeEncodeError in StatementError https://bitbucket.org/zzzeek/sqlalchemy/issue/3143/unicodeencodeerror-in-statementerror kodemi: My models contains unicode fields. From time to time I get this error when quering records: ``` #!python File "/usr/local/services/app/flights_handler.py", line 99, in fetch_flights_from_db flights = self.session.query(Flight).all() File "/home/fidsadm/.virtualenvs/vipport-services/local/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 2286, in all return list(self) File "/home/fidsadm/.virtualenvs/vipport-services/local/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 2398, in __iter__ return self._execute_and_instances(context) File "/home/fidsadm/.virtualenvs/vipport-services/local/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 2411, in _execute_and_instances close_with_result=True) File "/home/fidsadm/.virtualenvs/vipport-services/local/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 2402, in _connection_from_session **kw) File "/home/fidsadm/.virtualenvs/vipport-services/local/lib/python2.7/site-packages/sqlalchemy/orm/session.py", line 843, in connection close_with_result=close_with_result) File "/home/fidsadm/.virtualenvs/vipport-services/local/lib/python2.7/site-packages/sqlalchemy/orm/session.py", line 847, in _connection_for_bind return self.transaction._connection_for_bind(engine) File "/home/fidsadm/.virtualenvs/vipport-services/local/lib/python2.7/site-packages/sqlalchemy/orm/session.py", line 298, in _connection_for_bind self._assert_active() File "/home/fidsadm/.virtualenvs/vipport-services/local/lib/python2.7/site-packages/sqlalchemy/orm/session.py", line 210, in _assert_active % self._rollback_exception File "/home/fidsadm/.virtualenvs/vipport-services/local/lib/python2.7/site-packages/sqlalchemy/exc.py", line 242, in __str__ repr(self.statement), repr(params_repr) File "/home/fidsadm/.virtualenvs/vipport-services/local/lib/python2.7/site-packages/sqlalchemy/sql/util.py", line 254, in __repr__ return repr(self.params) UnicodeEncodeError: 'ascii' codec can't encode characters in position 0-8: ordinal not in range(128) ``` |