[GENERAL] ERROR: Could not convert UTF-8 to ISO8859-1

2005-04-28 Thread Fritz Bayer
Hello, my database encodes data as utf8. The data I want to select contains characters like äöü. If I select some columns and change the encoding to latin1, then I get the following error message: select created, keywords from requests; ERROR: Could not convert UTF-8 to ISO8859-1 If I set the

Re: [GENERAL] Encoding problem

2005-04-22 Thread Fritz Bayer
[EMAIL PROTECTED] (Andreas Seltenreich) wrote in message news:<[EMAIL PROTECTED]>... > Fritz Bayer schrob: > > > The problem is that alls the "ü" characters get displayed as "". > > > > Why is that so? > > This could happen when your loca

[GENERAL] Encoding problem

2005-04-20 Thread Fritz Bayer
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 "". Why is that so? fritz BTW: I set client encoding to latin1 and the database stores data in utf8

Re: [GENERAL] Encoding Issue with UNICODE

2005-04-12 Thread Fritz Bayer
[EMAIL PROTECTED] ("Daniel Verite") wrote in message news:<[EMAIL PROTECTED]>... > Fritz Bayer wrote: > > > I have a java program, which writes words containing german umlauts > > like äöü into the database. As you probably know, those characters > > bel

Re: [GENERAL] Encoding Issue with UNICODE

2005-04-12 Thread Fritz Bayer
[EMAIL PROTECTED] ("Magnus Naeslund(t)") wrote in message news:<[EMAIL PROTECTED]>... > Fritz Bayer wrote: > > Hello, > > > > I`m using postgresql 7.2.1. According to the following lines data in > > my database gets encoded as unicode. Server and clien

[GENERAL] Encoding Issue with UNICODE

2005-04-10 Thread Fritz Bayer
Hello, I`m using postgresql 7.2.1. According to the following lines data in my database gets encoded as unicode. Server and client communication seems to use unicode as well: woody=# select version(); version --- PostgreSQL 7.2.1 on i686