pymssql: Problem with Unicode string

Поиск
Список
Период
Сортировка
От orgilhp
Тема pymssql: Problem with Unicode string
Дата
Msg-id aace5677-7d0c-41fe-9657-922012ed6dc6@u11g2000prk.googlegroups.com
обсуждение исходный текст
Ответы Re: pymssql: Problem with Unicode string
Re: pymssql: Problem with Unicode string
Список pgsql-general
Hello!
I am using pymssql-1.9.908. And I have MSSQL2008 database server.
I ran following code from python 2.6:
-----------------------------------
        import pymssql
        conn = pymssql.connect(host='testserver', user='sa',
password='sa', database='testdb', as_dict=True)
        crms = conn.cursor()
        crms.execute('SELECT cc_Name FROM tblUsers')
        for line in crms.fetchall():
            print 'cc_Name:', self.unicodify(line['cc_Name'])
            break
        crms.close()
-----------------------------------
the result is-> cc_Name: ?????, ???
But the actual data is "Аймаг, хот" and I expect that the output would
be "cc_Name: Аймаг, хот".

Here is my question:
How to get Unicode data from MSSQL database using pymssql library?

Any suggestion would be highly appreciated!
regards,
Orgil.D

В списке pgsql-general по дате отправления:

Предыдущее
От: Matt Warner
Дата:
Сообщение: Re: Full Text Index Scanning
Следующее
От: orgilhp
Дата:
Сообщение: pymssql Connection to the database failed for an unknown reason