Denis wrote:

I need to obtain metadata about the columns in my database.

The problem is that column_info does not supply information about the signedness of the column, or I am missing something in the man page.

I've googled for some time but found no solution.

Any hints where to dig?


I am using MySQL 4.1.x and all the latest DBI and DBD::mysql on GNU/Linux.


I just checked a place where I'm calling column_info, and I get the field 'mysql_type_name' with the field description ( for example ):
mediumint(8) unsigned

Obviously that's mysql-specific, and you'll have to search in the string for it, but it's better than nothing. Maybe someone else knows a better way?

--
Daniel Kasak
IT Developer
NUS Consulting Group
Level 5, 77 Pacific Highway
North Sydney, NSW, Australia 2060
T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989
email: [EMAIL PROTECTED]
website: http://www.nusconsulting.com.au

Reply via email to