> > On Aug 10, 2012, at 5:19 AM, Warwick Prince wrote: > >> Hi All >> >> If I have a Column() object, is there a way of determining the sqlalchemy >> type from the dialect specific type? e.g. I have a Postgres TIMESTAMP >> column, and I want to be able to map that back the a sqa DateTime type. > > > column.type._type_affinity > I have moved on now with this information, but I've hit a snag which appears to be bug in either core or possibly (more likely) mysqlconnector.
When I ask for column.type._type_affinity on a LONGBLOB column in a MySQL database, it returns _Binary which is not correct (Should be LargeBinary). Please confirm if this is a core issue, or should I go hunting in the connector code? Cheers Warwick -- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalchemy@googlegroups.com. To unsubscribe from this group, send email to sqlalchemy+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en.