Encoding problem

From: fritz-bayer(at)web(dot)de (Fritz Bayer)
To: pgsql-general(at)postgresql(dot)org
Subject: Encoding problem
Date: 2005-04-20 13:27:19
Message-ID: a9c0aa9e.0504200527.31ad4679@posting.google.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Chris Browne 2005-04-20 13:39:18 Re: Simplified (a-la [G|N]DBM) DB access
Previous Message Terry Lee Tucker 2005-04-20 13:26:34 Re: UNSUBSCRIBE