Re: python, mssql and unicode

2005-11-04 Thread riek
Hi Diez :) I tried converting the query string to utf-16 but only got weird results. The problem might lie with the _mssql module (which pymssql is using, it's just a wrap around _mssql) that I am using... I'll post what I get from converting to utf-16 later, maybe you have an idea... -- http:/

Re: python, mssql and unicode

2005-11-03 Thread Diez B. Roggisch
[EMAIL PROTECTED] wrote: > Hello, > > I am using pymssql (http://pymssql.sourceforge.net/) to insert data > from a web-frontend (encoded in utf-8) into fields of type nvarchar of > an MS-SQL Server 2000. > > The problem is, ms-sql server uses ucs-2 and not utf-8. I have looked > around a bit but

python, mssql and unicode

2005-11-03 Thread riek
Hello, I am using pymssql (http://pymssql.sourceforge.net/) to insert data from a web-frontend (encoded in utf-8) into fields of type nvarchar of an MS-SQL Server 2000. The problem is, ms-sql server uses ucs-2 and not utf-8. I have looked around a bit but found no suitable solution to this proble