Encoding problem

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?

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