Re: unsigned datatype causing ct_fetch(): overflow?

Michael Peppler <[email protected]> Sat, 14 Apr 2007 17:18:54 +0200
Newsgroups gmane.comp.lang.perl.modules.dbi.sybase
Organization Peppler Consulting SaRL
Message-ID <[email protected]>
Note that this is fixed in the current test release (1.07_09, available 
at http://www.peppler.org/downloads, and will of course be fixed in the 
upcoming 1.08 release.

Michael

Humphrey Widjaja wrote:
> 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
> 
> 


-- 
Michael Peppler           -                 Peppler Consulting SaRL
[email protected]      -                  http://www.peppler.org
Sybase DBA/Developer      -   TeamSybase: http://www.teamsybase.com
Sybase on Linux FAQ       -   http://www.peppler.org/FAQ/linux.html