Unable to execute a query in Python/Django which contains non-latin characters

Question

I try to execute a query in Python/Django, but eventually I end up with ProgrammingError. My script looks like this:

#--coding: utf-8
...
import pyodbc
...
def testquery(request):
    cnx = pyodbc.connect("DRIVER=FreeTDS;SERVER=192.168.0.1;PORT=1433;DATABASE=mydatabase;UID=sa;PWD=password;TDS_Version=7.0;ClientCharset=UTF8;")
    cursor = cnx.cursor()
    cursor.execute("SELECT * FROM sys_Атрибут")
    ...

As you can see, the name of a table contains non-latin characters. If I instead query another table, whose name is in Latin, then it's ok.

I also tried this:

cursor.execute("SELECT * FROM ?",tablename)

And this:

cursor.execute("SELECT * FROM %s" % tablename)

But it has no effect.

In database manager itself on the host machine I can execute such queries. — Jacobian, Nov 10 '14 at 22:28
`from __future__ import unicode_literals cursor.execute(u'SELECT * FROM sys_Атрибут')` if it does not help that problem in `pyodbc` == database backend — madzohan, Nov 10 '14 at 22:33
I've just red somewhere about `pymssql`. Some people say that this library has less problems with unicode characters. I will check it. — Jacobian, Nov 10 '14 at 22:33
What problem can be in backend, if I can execute queries against "normal" tables with latin literals? — Jacobian, Nov 10 '14 at 22:35
Oh, I see what you mean. I will try to switch to `pymssql` and check if it helps. — Jacobian, Nov 10 '14 at 22:36
`cursor.execute(u'SELECT * FROM sys_Атрибут'.encode('utf-8'))` — madzohan, Nov 10 '14 at 22:44
@madzohan Magic! It works! You can make an answer from it. I guess it will be useful for future programmers — Jacobian, Nov 11 '14 at 06:04

score 1 · Accepted Answer · edited May 23 '17 at 12:20

1

"FreeTDS handles Unicode for you" https://stackoverflow.com/a/964825/3033586

cursor.execute(u'SELECT * FROM sys_Атрибут'.encode('utf-8'))

edited May 23 '17 at 12:20

Community

1
1

answered Nov 11 '14 at 17:55

madzohan

11,488
9
40
67

Unable to execute a query in Python/Django which contains non-latin characters

1 Answers1