getting exact sql type of query's result rowset in python

Question

As far as I know, standard Python DB api does not provide exact SQL type information of result rowset.

Is there anyway to get exact SQL type and some more detailed information like tinyint, bigint, nvarchar(100) for some result rowset rather than truncated python type like int, str ... ?

I think portability or module dependency is not important - something just work would be fine. (I'm working on windows, MS-SQL.)

Christian Witts · Accepted Answer · 2012-07-02 10:55:15Z

1

Use .description after your query to retrieve information regarding your data-types amongst other things.

cursor.execute('select some_column from some_table')
print cursor.description

.description

        This read-only attribute is a sequence of 7-item
        sequences.  

        Each of these sequences contains information describing
        one result column: 

          (name, 
           type_code, 
           display_size,
           internal_size, 
           precision, 
           scale, 
           null_ok)

answered Jul 2, 2012 at 10:55

Christian Witts

11.7k1 gold badge36 silver badges47 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

summerlight Over a year ago

Thanks for your answer, though 'description' member in cursor object does not provide exact SQL type information as my knowledge. (For example, there is no way to distinguish xml/nvarchar/varchar ...)

Collectives™ on Stack Overflow

getting exact sql type of query's result rowset in python

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related