Re: BUG #5221: errors converting string to utf8 - Mailing list pgsql-bugs

Craig Ringer <craig@postnewspapers.com.au> writes:
> On 1/12/2009 7:36 PM, DM wrote:
>> select convert('Vall\xe9e','LATIN1','UTF8');

> You expect the result 'Vallée', right? As in the utf-8 bytes
>    Vall\xc3\xa9e
> ?

The whole thing seems like an exercise in unnecessary pain anyway.
Why not just set client_encoding to LATIN1 and send your strings
as-is, letting the server deal with the encoding conversion
automatically?

            regards, tom lane