Re: SQLExecute fails question

Поиск
Список
Период
Сортировка
От tomas@nocrew.org (Tomas Skäre)
Тема Re: SQLExecute fails question
Дата
Msg-id 80658hbqwx.fsf@junk.nocrew.org
обсуждение исходный текст
Ответ на Re: SQLExecute fails question  ("Dave Page" <dpage@vale-housing.co.uk>)
Список pgsql-odbc
"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?


Greetings,

Tomas

В списке pgsql-odbc по дате отправления:

Предыдущее
От: "Dave Page"
Дата:
Сообщение: Re: psqlODBC / install / WinXP
Следующее
От: "Dave Page"
Дата:
Сообщение: Re: SQLExecute fails question