here's a patch against current cvs that improves cursor.description
i had difficulty finding a precise description of the semantics of the display size and internal size fields, so there may be an issue around those. for efficiency, i used dbcolinfo. this means it is "nearly" free to return all available meta-information about the columns of a result set to python, and any adjustments that need to be made to cursor.description can be made with minor adjustments to one function, _mapheader
(it would be good to have the windows version and the *nix version behave identically, but i'm not in a position to make such comparisons.)
thanks,
-ch
ch@murgatroid.com
ch@hpl.hp.com
patch against cvs for improved cursor.description
Thanks very much for the patch! Due to SF's website indolency I have never come across this post (there were no notification). We'll be reviewing this now. Please note that we moved pymssql to http://code.google.com/p/pymssql/ and all further development will be continued there.