Re: DBD::mysql retrieving column collation

Paul DuBois wrote:
> If you resort to parsing SHOW output, you might find the output of
> SHOW COLUMNS easier to deal with, because it's in row-and-column
> format. SHOW FULL COLUMNS displays an additional Collation column,
Thanks! I wasn't aware of SHOW FULL COLUMNS.

However I'm now successfully using the new information_schema database like this:

"select data_type,collation_name from information_schema.columns where table_schema=? and table_name=? and column_name=?"

Then if collation_name =~/bin/ it's a binary column.

cheers
John

-- 
MySQL Perl Mailing List
For list archives: 
http://lists.mysql.com/perl
To unsubscribe:    
http://lists.mysql.com/perl?unsub=lists@pantek.com