Hello Arik,
What did you find?
Meanwhile, I did another search, and this time I found mentions of
additional relevant Python modules:
- pyodbc (http://pyodbc.sourceforge.net/)
- pymssql (http://pymssql.sourceforge.net/) - needs fields to be
nvarchar or text rather than ntext
Are you using one of them? Which one would be the least painful for me
to install and convert my scripts from odbc into?
Thanks,
--- Omer
On Tue, 2007-12-18 at 04:43 -0800, Arik Baratz wrote:
> On 12/17/07, Omer Zak <[EMAIL PROTECTED]> wrote:
> > I encountered the following problem.
> > DB - MS-SQL Server, running on a MS-Windows XP machine.
> > Scripting language - Python 2.5.1
> > DB interface modules - Python win32 extension: odbc,dbi
> >
> > The relevant DB tables have Unicode fields (data type nchar and its
> > ilk). They are populated by strings including Hebrew glyphs.
> >
> > When I try to retrieve those tables in Python, the Hebrew glyphs become
> > question marks. Latin glyphs, digits, and space are faithfully
> > reproduced.
>
> This is interesting, I remember doing the very same thing and I got
> the results back as Python Unicode strings with all the trimmings.
>
> I'll dig into my archive for some source code example.
>
> -- Arik
--
Every good master plan involves building a time machine. Moshe Zadka
My own blog is at http://www.zak.co.il/tddpirate/
My opinions, as expressed in this E-mail message, are mine alone.
They do not represent the official policy of any organization with which
I may be affiliated in any way.
WARNING TO SPAMMERS: at http://www.zak.co.il/spamwarning.html
_______________________________________________
Python-il mailing list
[email protected]
http://hamakor.org.il/cgi-bin/mailman/listinfo/python-il
