[DB-SIG] kinterbas db column type
gh at ghaering.de
Wed Nov 26 10:43:26 EST 2003
Uwe Grauer wrote:
> i need to know the database column types returned by kinterbasdb.
> Implicit type conversion is i nice thing to have, but it hides the real
> types in the database.
> So how could i get this information?
Quoting the DB-API 2.0 (http://www.python.org/peps/pep-0249.html):
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). The first two items (name and type_code) are
mandatory, the other five are optional and must be set to
None if meaningfull values are not provided.
So you can compare the type_code with the constants in your DB-API
module (STRING, NUMBER, ...).
If you need the exact data types of table/view columns, you'll probably
need to query database meta tables for this information.
More information about the DB-SIG