sybperl-l Archive

From: "Humphrey Widjaja" <h4w301 at gmail dot com>
Subject: unsigned datatype causing ct_fetch(): overflow?
Date: Oct 15 2006 12:40PM

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