On 04/07/12 13:58, Asif Naeem wrote:
>> Patch attached. Asif, could you try a few things on a CP1252 database?
>
> First verify if your original test case now works and then try this:
>>
>>
> I have test the patch on Win64. postgres server is working fine now for
> WIN1252. Thanks.
>
>
>> create function enctest() returns text as $$
>> return b'tr\xc3\xb3spido'.decode('**utf-8')
>> $$ language plpython3u;
>>
>> select enctest(), encode(convert_to(enctest(), 'utf-8'), 'hex');
>>
>
> create function enctest() returns text as $$
> return b'tr\xc3\xb3spido'.decode('utf-8')
> $$ language plpython3u;
> select enctest(), encode(convert_to(enctest(), 'utf-8'), 'hex');
> enctest | encode
> ----------+--------------------
> tróspido | 7472c3b3737069646f
> (1 row)
>
> Please do let me know If you have any other query. Thanks.
Great, this looks correct.
Can we apply this to 9.2?
Cheers,
Jan