[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
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