Re: Wrong string length from unicode database in Borland's app

Alex Guryanow <gav@nlr.ru> writes:
> When pg-server is version 7.1.3 windows app works fine, but when
> pg-server is version 7.4.6 or 8.0beta4 under certain conditions the
> app receives strings with wrong lengths.

Are both servers set up with the same database encoding?  (Is the 7.1
server even compiled to support non-ASCII encodings?)

> But by executing the query
>     select volume, trim(number) from issue where mag_id = 25403;
> the datagrid component (that displays query's results) contains in
> second column values with length of 32769.

If you try the same query in plain psql, what do you get?  What is in
the wrong-length value, exactly?

            regards, tom lane