Thread: Problems with special character rendering

Problems with special character rendering

From
Thomas Bouffon
Date:
Hi,
I have a little problem with psql
with 8.4.6 ,
  select E'é\fr';
gives :
 ?column?
----------
 é\x0Cr
(1 ligne)

whereas with 8.1
select E'é\fr';
gives
 ?column?
----------
 é
  r
(1 row)

I tried changing both client/server encodings, etc.
Why does 8.4 not render \f as a form feed ?

Thanks,
Thomas

Re: Problems with special character rendering

From
Tom Lane
Date:
Thomas Bouffon <thomas.bouffon@gmail.com> writes:
> Hi,
> I have a little problem with psql
> with 8.4.6 ,
>   select E'�\fr';
> gives :
>  ?column?
> ----------
>  �\x0Cr
> (1 ligne)

> whereas with 8.1
> select E'�\fr';
> gives
>  ?column?
> ----------
>  �
>   r
> (1 row)

> I tried changing both client/server encodings, etc.
> Why does 8.4 not render \f as a form feed ?

It does.  psql just displays form feeds (and other control characters)
in a less broken way than it used to.

            regards, tom lane