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

Re: further to last e-mail

From: "Graham Vickrage" <graham(at)digitalplanit(dot)com>
To: "Hiroshi Inoue" <Inoue(at)tpf(dot)co(dot)jp>
Cc: <pgsql-odbc(at)postgresql(dot)org>
Subject: Re: further to last e-mail
Date: 2002-08-01 09:17:10
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-odbc
'Text as LongVarChar' is ticked, and the max char length is set to 8190
(default from install). The max length in my table of this particualar text
field is 587 characters.

Thanks Graham.

-----Original Message-----
From: Hiroshi Inoue [mailto:Inoue(at)tpf(dot)co(dot)jp]
Sent: 01 August 2002 07:32
To: Graham Vickrage
Cc: pgsql-odbc(at)postgresql(dot)org
Subject: Re: [ODBC] further to last e-mail

Graham Vickrage wrote:
> I have tracked down the problem (but not the solution), it
> would appear that the data type 'text' is causing the problems.
> If a column of type text is included in the query then only one
> row is returned, else all rows are.
> Why is this, is it the ODBC driver or NT Server 4 or something else?

How are you setting *Text As LongVarChar* option ?
And how big the actual size of the text field ?

Hiroshi Inoue

In response to


pgsql-odbc by date

Next:From: Hiroshi InoueDate: 2002-08-01 10:05:45
Subject: Re: further to last e-mail
Previous:From: Hiroshi InoueDate: 2002-08-01 06:32:09
Subject: Re: further to last e-mail

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