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

2014-07-30 Thread Viktor Nagy
FYI, I've found the corresponding pymssql bug. I hope for the fix being included in their next minor release. https://github.com/pymssql/pymssql/issues/185 2014. július 27., vasárnap 16:25:23 UTC+2 időpontban Michael Bayer a következőt írta: On Jul 27, 2014, at 8:58 AM, Viktor Nagy

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

2014-07-30 Thread Michael Bayer
that’s great news! On Jul 30, 2014, at 6:11 PM, Viktor Nagy viktor.n...@gmail.com wrote: FYI, I've found the corresponding pymssql bug. I hope for the fix being included in their next minor release. https://github.com/pymssql/pymssql/issues/185 2014. július 27., vasárnap 16:25:23 UTC+2

[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

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 viktor.n...@gmail.com 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