Re: SQLExecute fails question - Mailing list pgsql-odbc

From Dave Page
Subject Re: SQLExecute fails question
Date
Msg-id E7F85A1B5FF8D44C8A1AF6885BC9A0E41A73AF@ratbert.vale-housing.co.uk
Whole thread Raw
In response to SQLExecute fails question  ("Joost Kraaijeveld" <J.Kraaijeveld@Askesis.nl>)
List pgsql-odbc

> -----Original Message-----
> From: Tomas Skare [mailto:tomas@junk.nocrew.org] On Behalf Of
> Tomas Skäre
> Sent: 21 July 2004 11:23
> To: Dave Page
> Cc: pgsql-odbc@postgresql.org
> Subject: Re: [ODBC] SQLExecute fails question
>
> "Dave Page" <dpage@vale-housing.co.uk> writes:
>
> > > [mailto:pgsql-odbc-owner@postgresql.org] On Behalf Of Joost
> > > Kraaijeveld
> > >
> > > Hi all,
> > >
> > > When I get this error message from a SQLExecute():
> > >
> > > [2152] SQLSTATE = HY000
> > > [2152] Native rc Code = 7
> > > [2152] Message: ERROR:  value too long for type character(20)
> > >
> > > does that mean that one of my columns as that is defined as
> > > char(20) receives more data than 20 chars or does that mean that
> > > column 20 receives to many chars?
> >
> > The first. The data is too long for char(20).
>
> It would be very helpful sometimes to know what column that
> failed. But maybe that's really a PostgreSQL issue, and not
> the ODBC driver?

Yes it is.

Regards, Dave.

pgsql-odbc by date:

Previous
From: tomas@nocrew.org (Tomas Skäre)
Date:
Subject: Re: SQLExecute fails question
Next
From: Theodore Petrosky
Date:
Subject: Re: 07.05.0001 Snapshot available