Encoding problem - Mailing list pgsql-general

From fritz-bayer@web.de (Fritz Bayer)
Subject Encoding problem
Date
Msg-id a9c0aa9e.0504200527.31ad4679@posting.google.com
Whole thread Raw
Responses Re: Encoding problem  (Richard Huxton <dev@archonet.com>)
Re: Encoding problem  (Andreas Seltenreich <seltenreich@gmx.de>)
List pgsql-general
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

pgsql-general by date:

Previous
From: ptjm@interlog.com (Patrick TJ McPhee)
Date:
Subject: Re: What means Postgres?
Next
From: Michael Fuhr
Date:
Subject: Re: lots of puzzling log messages