Le jeudi 23 décembre 2010 18:21:55, John R Pierce a écrit :
> On 12/23/10 2:34 AM, Marc Cousin wrote:
> > No, from a Linux psql client (inside a kde konsole). You can setup any
> > charset in it. I have exactly the same behaviour with psql under windows
> > anyway, with a chcp 1252 in the cmd console. It's not a console charset
> > problem, I've tripled checked that :)
> > And anyway, this character shouldn't get into the database as UTF8, as it
> > is 1252 (hence the error message).
> does client_encoding affect names ? (I'm asking because I have no idea).
Yes (for the Linux server, for Windows it fails).
I have exactly the same problem if I test with LATIN9 (except that the utf8
error message has a different value for the bad character).
> what encodings are the database clusters on the two platforms?
Oh. Both are UTF-8.
In response to
pgsql-bugs by date
|Next:||From: Trimurthulu Bandaru||Date: 2010-12-24 11:57:12|
|Subject: insert statement going into infinite loop|
|Previous:||From: John R Pierce||Date: 2010-12-23 17:21:55|
|Subject: Re: BUG #5801: characters not encoded properly for column