Hello
Rather than storing strings as UTF8 in VARCHAR, I would like to store
the strings as NVARCHAR in MSSQL.
It appears that is what MSSQL2Adapter is meant to do, but there were
errors when I tried to use it.
I believe a couple changes in the MSSQLAdapater code could make it
work (it seems to work for me).
I'm using python 2.7, pyodbc 2.1.8.
Eric
- if fieldtype == 'string' or fieldtype == 'text' and value[:1]=="'":
+ if (fieldtype == 'string' or fieldtype == 'text') and value[:1]=="'":
- return self.log_execute(a,'utf8')
+ return self.log_execute(a.decode('utf-8'))
