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