From: | tomas(at)nocrew(dot)org (Tomas =?iso-8859-1?q?Sk=E4re?=) |
---|---|
To: | "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk> |
Cc: | <pgsql-odbc(at)postgresql(dot)org> |
Subject: | Re: SQLExecute fails question |
Date: | 2004-07-21 10:22:54 |
Message-ID: | 80658hbqwx.fsf@junk.nocrew.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
"Dave Page" <dpage(at)vale-housing(dot)co(dot)uk> writes:
> > [mailto:pgsql-odbc-owner(at)postgresql(dot)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?
Greetings,
Tomas
From | Date | Subject | |
---|---|---|---|
Next Message | Dave Page | 2004-07-21 10:31:37 | Re: SQLExecute fails question |
Previous Message | Dave Page | 2004-07-21 07:43:25 | Re: psqlODBC / install / WinXP |