how do i find out whether column is signed or not?

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.

--
Denis

Re: how do i find out whether column is signed or not?

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: dkasak@nusconsulting.com.au
website: http://www.nusconsulting.com.au