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

2005-09-23 Thread Denis
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.

is there a way to obtain whether column is signed or unsigned?

2005-09-23 Thread Denis
I need to obtain metatdata about a columns in the MySQL database. Some of my columns are signed, others are not. The column_info doesn't not return any information, whether the column is signed or not. Any hints where to dig? -- Denis

Possible bug in DBD-ADO 2.94 bind_param

2005-09-23 Thread Knut Tvedten
Hi Using prepared statements doesn't work correctly for driver DBD-ADO version 2.94 on MS SQL Server 2000 (Provider=sqloledb). Given CREATE TABLE t1(c1 VARCHAR(255)) The code snippet triggers the error: ... my $stmt = $dbh->prepare('INSERT INTO t1(c1) VALUES(?)'); $stmt->bind_param(1, 'A string'

Re: DBD-DB2 install issue

2005-09-23 Thread Dan Scott
Ah, one other _very_ likely possibility is that the user running the tests (or any other script using DBD::DB2) had not inherited the DB2 instance profile before running the tests. The DB2 instance profile sets the environment variables that enable the DB2 client to find things like libdb2.so,

(Fwd) Fetching CLOB variable fron Oracle in Perl version 5.005_03

2005-09-23 Thread Tim Bunce
- Forwarded message from Sachin Bardeo <[EMAIL PROTECTED]> - Subject: Fetching CLOB variable fron Oracle in Perl version 5.005_03 Date: Thu, 22 Sep 2005 12:25:19 +0530 From: "Sachin Bardeo" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> X-imss-version: 2.031 X-imss-result: Passed X-imss-scor