From: markh@clockworkweb.com (Mark Himsley)
To: pgsql-interfaces@postgresql.org
Subject: varchar() access
Date: Thu, 28 Jan 1999 18:17:51 GMT
Keywords: home
Organization: Clockwork Web
Reply-To: markh@clockworkweb.com
Message-ID: <36b4a95d.2361109@jupiter.clockworkweb.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

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.