On Sat, 2009-06-27 at 19:20 +0000, saint wrote:
> set client_encoding to 'WIN1250';
> insert into public.test(col) values('‰');
You're lying to the server about the client encoding in one or both
cases. I can't know which without knowing what program you're talking to
the server with and how it's set up.
'SET client_encoding' tells the server what encoding to expect incoming
data in. It doesn't change what encoding the client sends that data in.
If your client has a different default encoding to that of the server,
you can inform the server that the client will be sending differently
In other words, you can't use 'SET client_encoding' to change what
encoding the client uses, only how the server interprets the bytes it
gets from the client.
In response to
pgsql-bugs by date
|Next:||From: Craig Ringer||Date: 2009-06-29 11:08:00|
|Subject: Re: BUG #4875: /etc/init.d/postgresql status shows
postmaster is stopped when executed as user|
|Previous:||From: Vladimir Lavrentiev||Date: 2009-06-29 06:58:59|
|Subject: BUG #4893: Grants on inherited tables checks before constraint exclusion see, that table not needed|