Yaroslav - 2014-09-16

I am using 3.2.0-4-amd64 #1 SMP Debian 3.2.57-3 x86_64 GNU/Linux
and was trying to port script that searches MS SQL DATABASE in windows enviremnt
but when i get code executed it does not find anything? but in windows it does.
I suppose it comes from encoding problems, but i do not know how to manage it

I was setting
locale.setlocale(locale.LC_ALL, 'ru_RU.CP1251')
and
locale.setlocale(locale.LC_ALL, 'ru_RU.UTF-8')

was trying to use charset='cp1251' in connect function
con = pymssql.connect(host=dbsrv0,user=dbuser,password=dbpwd,database=db, charset='cp1251')
and still code empty string.

query="SELECT DISTINCT \ PATIENTS.NOMER_ANALIZA,PATIENTS.PATIENTS_ID,FM_BILL.DATE_CREATE,FM_SERV.CODE,PATIENTS.NOM, PATIENTS.PRENOM, PATIENTS.PATRONYME, PATIENTS.POL,PATIENTS.NE_LE,PATIENTS.FAZA_BEREMENNOSTI,
WHERE PATIENTS.NOM = '" + ptsurname.encode('cp1251') + "' AND PATIENTS.PRENOM = '" + ptname.encode('cp1251') + "' AND PATIENTS.PATRONYME = '" + ptlastname.encode('cp1251') + "' AND PATIENTS.NE_LE = '" + bdate.encode('cp1251') + "'"

cur.execute(query)
ptrz=cur.fetchall()
con.commit()

SELECT DATABASEPROPERTYEX('Medialog', 'Collation') SQLCollation
on Database returns
SQL_Latin1_General_CP1251_CI_AS

Is there a way to find out issue