Обсуждение: varchar() access

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.