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 ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
