Re: SQLExecute fails question - Mailing list pgsql-odbc

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

> -----Original Message-----
> From: pgsql-odbc-owner@postgresql.org
> [mailto:pgsql-odbc-owner@postgresql.org] On Behalf Of Joost
> Kraaijeveld
> Sent: 20 July 2004 23:25
> To: pgsql-odbc@postgresql.org
> Subject: [ODBC] SQLExecute fails question
>
> 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).

Regards, Dave

pgsql-odbc by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: 07.05.0001 Snapshot available
Next
From: "Dave Page"
Date:
Subject: Re: 07.05.0001 Snapshot available