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
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your
message can get through to the mailing list cleanly
