varchar() access - Mailing list pgsql-interfaces

From markh@clockworkweb.com (Mark Himsley)
Subject varchar() access
Date
Msg-id 36b4a95d.2361109@jupiter.clockworkweb.com
Whole thread Raw
List pgsql-interfaces
No one has any comment at all?
Not even 'your a dick-head'!

Oh well, I guess I'll have to re-write my code to cope with this problem
that I am having.

> 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: Clark Evans
Date:
Subject: Python Interface
Next
From: Brian Schneider
Date:
Subject: unsubscribe