SQL server data types????

Aahz Maruch aahz at panix.com
Tue Oct 24 02:02:41 EDT 2000


In article <8t2bnk$ns5$1 at nnrp1.deja.com>,  <muwanda at my-deja.com> wrote:
>
>and if I have in a table (SQL server) a datatype nvarchar, Python shell
>send the follow error:
>
>InterfaceError: SQL type (code -9) not implemented
>
>To solve this erro, i need make a cast, but it's so hard, because I
>have a lot a fields nvarhcar....

Ugh.  Yeah, I remember that.  Unfortunately, I'm not working at that job
any more, so I can't play with SQL Server to test things.  I do recall
that we used a hacked version of mxODBC for a while when we were using
Python 1.5.1, so that's one possibility.  Another option would be to
create views, but that creates messy update issues.  I forget what
nvarchar is -- is that the Unicode type?  If so, Lemburg will probably
fix that in the 2.0 version of mxODBC, because 2.0 is the first standard
version of Python to support Unicode.
-- 
                      --- Aahz (Copyright 2000 by aahz at pobox.com)

Androgynous poly kinky vanilla queer het    <*>     http://www.rahul.net/aahz/
Hugs and backrubs -- I break Rule 6

"Boy, I got vision, and the rest of the world wears bifocals."  --Butch Cassidy



More information about the Python-list mailing list