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

Re: SQLExecute fails question

From: "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk>
To: "Joost Kraaijeveld" <J(dot)Kraaijeveld(at)Askesis(dot)nl>,<pgsql-odbc(at)postgresql(dot)org>
Subject: Re: SQLExecute fails question
Date: 2004-07-21 07:12:17
Message-ID: E7F85A1B5FF8D44C8A1AF6885BC9A0E41A7398@ratbert.vale-housing.co.uk (view raw or flat)
Thread:
Lists: pgsql-odbc
 

> -----Original Message-----
> From: pgsql-odbc-owner(at)postgresql(dot)org 
> [mailto:pgsql-odbc-owner(at)postgresql(dot)org] On Behalf Of Joost 
> Kraaijeveld
> Sent: 20 July 2004 23:25
> To: pgsql-odbc(at)postgresql(dot)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

Responses

pgsql-odbc by date

Next:From: Dave PageDate: 2004-07-21 07:31:28
Subject: Re: 07.05.0001 Snapshot available
Previous:From: Peter EisentrautDate: 2004-07-20 23:38:26
Subject: Re: 07.05.0001 Snapshot available

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