[freetds] error_handler: Data-conversion resulted in overflow.

ZIGLIO, Frediano, VF-IT Frediano.Ziglio at vodafone.com
Tue Aug 31 05:36:42 EDT 2004


> 
> We are using freetds to connect to a MSQL database.
> 
> When reading certain tables, we have no errors but other tables give
> the error:
> error_handler: Data-conversion resulted in overflow.
> for each line of results.
> 
> This does not occur with other drivers that we use on this database.
> 
> Could someone please advise possible cause of error and how 
> we might fix it.
> 
> The table where we have an error is pretty standard as follows FWIW:
> 
>  CREATE TABLE Event (
>         EventTypeKey         smallint NOT NULL,
>         EventKey             int IDENTITY,
>         OrgTainerKey         char(6) NULL,
>         DocumentExternalReference varchar(20) NULL,
>         DocumentDate         smalldatetime NOT NULL,
>         StartDate            smalldatetime NULL,
>         EndDate              smalldatetime NULL,
>         Narrative            varchar(50) NULL,
>         CapturedBy           varchar(20) NULL,
>         EntryDate            smalldatetime NOT NULL,
>         Status               tinyint NULL
>  )
> 
> 
> Thanks.
> 

It's very hard to say... which library are you using ?? ctlib or dblib ?
Do you use PHP or others scripts ?
Perhaps you binded a varchar with a too small char array... Are you
using some multibyte character codings (utf8) ?

freddy77



More information about the FreeTDS mailing list