From: markh@clockworkweb.com (Mark Himsley)
To: pgsql-interfaces@postgresql.org
Subject: varchar() access
Date: Tue, 26 Jan 1999 23:33:04 GMT
Keywords: home
Organization: Clockwork Web
Reply-To: markh@clockworkweb.com
Message-ID: <36af4d47.5005609@jupiter.clockworkweb.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

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.