unsigned datatype causing ct_fetch(): overflow?

"Humphrey Widjaja" <[email protected]> Sun, 15 Oct 2006 20:40:03 +0800
Newsgroups gmane.comp.lang.perl.modules.dbi.sybase
Message-ID <[email protected]>
Hi,

I'm using ASE Express 15 and DBD-Sybase 1.07.
Is it true that DBD-Sybase 1.07 can not accept unsigned datatype from ASE 15?

I create a simple table:

create table asdf (
   num unsigned smallint
)

insert into asdf values (32768)

When I fetch the table, it gave me error message:

Message String: ct_fetch(): user api layer: internal common library
error: The bind of result set item 1 resulted in an overflow.

Its OK when I insert 32767 (max of signed smallint).

Regards,

Humphrey