Re: Encoding problem

Fritz Bayer wrote:
> Hi,
>
> when I enter the following SELECT into psql
> select * from mytable where data like '%ü%'
> I get a selection of a couple of rows.
> The problem is that alls the "ü" characters get displayed as "<FC>".
>
> Why is that so?

Probably something in your terminal setup. I always have endless trouble
with accented characters on the different systems I use.

> fritz
>
> BTW: I set client encoding to latin1 and the database stores data in
> utf8 and
> I'm running postgresql under the following system: PostgreSQL 7.2.1 on
> i686-pc-linux-gnu, compiled by GCC 2.95.4

You should upgrade to the most recent 7.2.x version immediately, and I'd
recommend 8.0.x as soon as possible.

--
Richard Huxton
Archonet Ltd