On Mon, Oct 13, 2003 at 07:52:12PM -0500, Paul DuBois wrote: > >Before I hare off and write a bunch of testing scripts, I'd just like to > >know if I'm on the right track. Will I be able to obtain this information, > >and is column_info the right way to do it? > > I don't know if column_info can do it,
It can and does, but is broken (with a trivial fix) in the current release. > but you don't need to write > the code. Go to http://www.kitebird.com/mysql-perl/ and get the > webdb distribution. The WebDB/TableInfo.pm file in it has a class that > uses SHOW COLUMNS to get the column information and yanks it apart. > Part of the information is the set of SET or ENUM values. > > Or, if you want to write the code anyway, this might give you some ideas. If you can't hack the DBD/mysql.pm file to fix it (see my other email) then you could also copy the column_info method from here: http://search.cpan.org/src/RUDY/DBD-mysql-2.9003_1/lib/DBD/mysql.pm Tim.
