| Lists: | pgsql-odbc |
|---|
| From: | "Graham Vickrage" <graham(at)digitalplanit(dot)com> |
|---|---|
| To: | <pgsql-odbc(at)postgresql(dot)org> |
| Subject: | further to last e-mail |
| Date: | 2002-07-31 21:10:32 |
| Message-ID: | NDBBJABDILOPAOOMFJHOMEPKDJAA.graham@digitalplanit.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-odbc |
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.
| From: | Hiroshi Inoue <Inoue(at)tpf(dot)co(dot)jp> |
|---|---|
| To: | Graham Vickrage <graham(at)digitalplanit(dot)com> |
| Cc: | pgsql-odbc(at)postgresql(dot)org |
| Subject: | Re: further to last e-mail |
| Date: | 2002-08-01 06:32:09 |
| Message-ID: | 3D48D5E9.FF27B5C2@tpf.co.jp |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-odbc |
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/
| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| 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/
| From: | Hiroshi Inoue <Inoue(at)tpf(dot)co(dot)jp> |
|---|---|
| To: | Graham Vickrage <graham(at)digitalplanit(dot)com> |
| Cc: | pgsql-odbc(at)postgresql(dot)org |
| Subject: | Re: further to last e-mail |
| Date: | 2002-08-01 10:05:45 |
| Message-ID: | 3D4907F9.80446482@tpf.co.jp |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-odbc |
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/