Craig Ringer 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 LAT
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
?
ERROR: invalid byte sequence for encoding "UTF8": 0xe965
HINT: This error can also happen if the byte sequence does not match the
enc
