Thread: further to last e-mail

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?

Thanks in advance.

Graham.

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/

'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@tpf.co.jp]
Sent: 01 August 2002 07:32
To: Graham Vickrage
Cc: pgsql-odbc@postgresql.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/

Graham Vickrage wrote:
>
> '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.

Could you send me the MyLog debug output ?

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