FreeTDS Development Group

["Lowden, James K" <LowdenJK AT bernstein.com>]

> From: Stefan Sonnenberg-Carstens [mailto:s.sonnenberg AT coolspot.de]
> Sent: February 21, 2003 3:05 AM
>
> We have a productive Site running under FreeTDS 0.60/PHP 
> 4.2.3 under Debian
> Linux 3.0/Testing.
> It works fine with the MS SQL Server 2000 SP3.
> Yesterday I had to reinstall PHP and IBM DB2 Support, so I decided to
> install new from scratch.
> The System now is a Debian 3.0 UNSTABLE, with gcc 3.2 etc.
> PHP's version is 4.3.1, FreeTSD remains 0.60, though it 
> worked in the past.
> After I transfered the Page, this was shown in the apache error log :
> 
> member:/usr/local/apache/logs# tail error_log
> error_handler: Data-conversion resulted in overflow.
> error_handler: Data-conversion resulted in overflow.
> error_handler: Data-conversion resulted in overflow.
> error_handler: Data-conversion resulted in overflow.
> [Thu Feb 20 16:14:55 2003] [notice] child pid 714 exit signal 
> Segmentation fault

Stefan, 

I doubt it's a compiler issue.  The error is a bit misleading IMO:
"overflow" normally means "too big to represent in this binary format", like
trying to stuff 257 into a byte.  These messages, however, are generated
converting to TEXT or CHAR/VARCHAR, and mean "the resulting string didn't
fit in the buffer you provided."  

Looks every bit a data problem.  You could set TDSDUMP to get a closer look,
or change the error message (it would be nice if it said something like "X
bytes of src type S require more than the provided Y bytes of dest type D").
We can convert any => varchar, so an intelligible error message should be
possible.  

It's possible you need to set your text size to something smaller. 

HTH.

--jkl


The information contained in this transmission may contain privileged and
confidential information and is intended only for the use of the person(s)
named above.  If you are not the intended recipient, or an employee or agent
responsible for delivering this message to the intended recipient, any
review, dissemination, distribution or duplication of this communication is
strictly prohibited. If you are not the intended recipient, please contact
the sender immediately by reply e-mail and destroy all copies of the
original message. Please note that we do not accept account orders and/or
instructions by e-mail, and therefore will not be responsible for carrying
out such orders and/or instructions.