Skip site navigation (1) Skip section navigation (2)

Re: SQLExecute fails question

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 (view raw or flat)
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

In response to

pgsql-odbc by date

Next:From: Dave PageDate: 2004-07-21 10:31:37
Subject: Re: SQLExecute fails question
Previous:From: Dave PageDate: 2004-07-21 07:43:25
Subject: Re: psqlODBC / install / WinXP

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group