DBD::mysql retrieving column collation

Hi folks,

I've written a schema sync script which allows me to make schema updates 
on multiple servers without disturbing data, and I've just added the 
ability to check column types but can't see what the collation type is 
from a DBD::mysql statement handle!

Is it possible to retrieve a column's collation from a statement handle?

I need to know if a column is binary or not - eg. 'varchar(255) binary' 
or just 'varchar(255)'

I'm about to resort to parsing the output of  'show create table' as I 
can't see any other way!

cheers
John


-- 
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe:    http://lists.mysql.com/[email protected]