Re: Query truncation problems

Paul Haddon wrote:
>
> I'm getting truncation errors when I try to retrieve more than
> 65k worth of data from a field.
>
> I'm accessing Postgresql on Linux from Cold Fusion 4 on NT.
>
> Version info:
>
> Global Options:
> Version='07.01.0009', fetch=100, socket=4096, unknown_sizes=0,
> max_varchar_size=254, max_longvarchar_size=8190
> disable_optimizer=0, ksqo=1, unique_index=1, use_declarefetch=0
> text_as_longvarchar=1, unknowns_as_longvarchar=0, bools_as_char=1
> extra_systable_prefixes='dd_;', conn_settings=''
>
> PostgreSQL version string = 'PostgreSQL 7.1.3 on i686-pc-linux-gnu,
> compiled by GCC egcs-2.91.66'
>
> I can insert a record ok, and confirm that it's correct by looking
> at it with psql on the Linux host, but when I try to retrieve it
> it's missing everything after the 65000 character mark.
>
> Looking at the logs shows:
>
> The 5th item was truncated
> The buffer size = 65000
>
> Do I have one of the settings incorrect, or is it a problem with
> the driver?

Each application has its own limitation.
Doesn't Cold Fusion 4 have a limitation that the text size
limit <= 65000 ?
I was able to retrieve the text data >= 65k using ADO.

regards,
Hiroshi Inoue