Re: [GENERAL] pymssql: Problem with Unicode string

2011-01-29 Thread Raymond O'Donnell 

On 29/01/2011 14:52, orgilhp wrote:

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


I think you'd have a better chance of getting an answer from a list on 
MSSQL; this one is devoted to PostgreSQL.


That said, they're a helpful bunch around here, so you never know. :-)

Ray.

--
Raymond O'Donnell :: Galway :: Ireland
r...@iol.ie

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] pymssql: Problem with Unicode string

2011-01-29 Thread Thom Brown 
On 29 January 2011 14:52, orgilhp  wrote:
> 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

This is a PostgreSQL mailing list.  Please direct this question to an
MSSQL or Python list instead.

-- 
Thom Brown
Twitter: @darkixion
IRC (freenode): dark_ixion
Registered Linux user: #516935

-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] pymssql: Problem with Unicode string

2011-01-29 Thread orgilhp 
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

-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general