Data from from pgsql db is truncated when viewed in accesss

[rubberjonnie]

We have a PGSQL database which sits behind our support ticket management
system, which is version 7.3.4.
One of our employees uses an Access report to view and print out the
information contained in certain fields, those used for showing what work has
been done. Whenever she tries to view this data the fields are truncated and
only show part of the information. For example, if sombody has copied the
text from an email into the ticket, some or all of the data is lost when
being viewed in Access. Sometimes you see whats in the middle, sometimes
whats at the end, somtimes even just a single character. I can replicate the
problem easily using my PC(Drivers on my machine are 7.03.02, as are hers).
Having enabled pgsql logging on my PC, the log file seems to indicate that
the data is being returned, but Access is not displaying it. Any ideas
anybody?
Any help gratefully received, Jonathan

 

[czerwinski]

Hello,

the same problem encounters when I view linked paradox tables.
certain text field is truncated. Funny enough this happens not alway
after the same position. Sometimes after 32, 20, 25, characters -
could not detect any systematics behind the truncation.

Please give hints how to solve or work around this problem. - All hel
and information is welcome!

Thanks in advance,

Cz