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

Alex Guryanow <gav(at)nlr(dot)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