supporting year type in DBD/mysql.pm column_info? - Karl Berry - com.mysql.lists.perl

1 message in com.mysql.lists.perlsupporting year type in DBD/mysql.pm ...

From	Sent On	Attachments
Karl Berry	19 Dec 2004 17:13

Subject:	supporting year type in DBD/mysql.pm column_info?
From:	Karl Berry (ka...@freefriends.org)
Date:	12/19/2004 05:13:24 PM
List:	com.mysql.lists.perl

Greetings,

I happened to define a couple of columns using the mysql type YEAR. Calling column_info on them reports:

unsupported column 'year_start' type 'year' treated as varchar at /usr/local/lib/perl5/...

Any chance of supporting this type? (I checked 2.9004, the latest I saw on CPAN, and did not see it mentioned.)

Looking at the definition in mysql.pm, I suspect it can be handled similarly to date* and time*. Unfortunately I don't know about about mysql and DBD-mysql internals to attempt a patch.

(It would also be nice to be able to turn off that warning.)

Thanks for the great software.