Re: [sqlalchemy] mssql queries with accented column names fails

2014-07-27 Thread Michael Bayer
On Jul 27, 2014, at 8:58 AM, Viktor Nagy wrote: > > /Users/viktornagy/.virtualenvs/odoo/lib/python2.7/site-packages/pymssql.so in > pymssql.Cursor.execute (pymssql.c:6347)() > > OperationalError: (OperationalError) (105, "Unclosed quotation mark after the > character string 'BiztKod1_1)s'.DB

[sqlalchemy] mssql queries with accented column names fails

2014-07-27 Thread Viktor Nagy
I'm connecting to a MSSQL server using pymssql+freetds. I could connect well, and managed to reflect the original tables. In order to map them to python object's, I'm adding ascii column keys, and then simply declare a declarative ORM: biztosito_columns_mapping = { 'BiztKod': 'pk', # this