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: NDBBJABDILOPAOOMFJHOAEPODJAA.graham@digitalplanit.com (view raw or flat)
Thread:
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 ?

regards,
Hiroshi Inoue
	http://w2422.nsk.ne.jp/~inoue/



In response to

Responses

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-2014 The PostgreSQL Global Development Group