On Wed, 2005-05-04 at 19:16, Mohankumar wrote: > Hi Folks, > I am using the perl version 5.005_02 built for MSWin32-x86 and sybase > 9.0.0. I have a DB and a table. I have used bigint as datatype for some > columns in a table. The bigint values are stored correctly in database. While > I trying to fetch the columns from the table, the columns which are having > bigint datatypes (with values greater than 8-digits) are not fetched and it > throws the below error. The bigint values with 8-digits or less canbe fetched > displayed correctly. Please let me know the method to fetch the bigint values. > > DBD::ASAny::st fetchrow failed: Cannot convert 99999999454 to a > varchar (DBD: fetch failed) at c:\perl\test.pl line 28.
Maybe not exactly what you want - but a workaround would be: select convert(varchar, the_bit_int_column) from .... as that moves the conversion from the client to the server. Michael -- Michael Peppler - [EMAIL PROTECTED] - http://www.peppler.org/ Sybase DBA/Developer Sybase on Linux FAQ: http://www.peppler.org/FAQ/linux.html
