varchar() access - Mailing list pgsql-interfaces

From markh@clockworkweb.com (Mark Himsley)
Subject varchar() access
Date
Msg-id 36af4d47.5005609@jupiter.clockworkweb.com
Whole thread Raw
List pgsql-interfaces
I'm accessing a postgres 6.3 server on Linux 2.0.35 using the 6.40.0004
ODBC driver on NT 4S.

I am having a problem with varchar columns being truncated to 4K bytes
when coming from the backend, although I can store > 4K into the
backend.

I have set max LongVarChar to 7000 and -4 (as suggested in the FAQ)
I have tried checking and not checking the 'text as LongVarChar' box.

I have seen the problem in Access 97 and ColdFusion 4 on 2 separate
servers.

I'm I doing something wrong, have I got the wrong end of a stick, or do
I have to use large objects...

Thanks, in advance, for any help.

--
Mark Himsley.
Technical Director,
Clockwork Web.

pgsql-interfaces by date:

Previous
From: rob
Date:
Subject: Re: pgsql-interfaces-digest V1 #206
Next
From: "񊀔"
Date:
Subject: subscribe pgsql-admin