[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:
>         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) ?


More information about the FreeTDS mailing list