Re: invalid byte sequence ?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Peter Eisentraut <peter_e(at)gmx(dot)net>
Cc: pgsql-general(at)postgresql(dot)org, Andreas <maps(dot)on(at)gmx(dot)net>, Bruce Momjian <bruce(at)momjian(dot)us>
Subject: Re: invalid byte sequence ?
Date: 2006-08-24 17:17:49
Message-ID: 6998.1156439869@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

Peter Eisentraut <peter_e(at)gmx(dot)net> writes:
> Tom Lane wrote:
>> A possible solution therefore is to have psql or libpq drive the
>> client_encoding off the client's locale environment instead of
>> letting it default to equal the server_encoding.

> I have been proposing that for years, but just about now the Japanese
> would speak up and protest ... I say, rush this in before anyone
> notices.

I guess the key point might be "what do we do if the client locale
is C?" Perhaps if it's C, we continue to use the server encoding
as we have in the past. This would be a reasonable fallback in
other cases where we fail to deduce an encoding from the locale, too.

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Michael Fuhr 2006-08-24 17:37:10 Re: Large database design advice
Previous Message Michael Fuhr 2006-08-24 17:16:05 Re: Large database design advice

Browse pgsql-hackers by date

  From Date Subject
Next Message Teodor Sigaev 2006-08-24 17:40:13 Re: tsvector/tsearch equality and/or portability issue
Previous Message Tom Lane 2006-08-24 17:15:48 Re: Autovacuum on by default?