Re: [GENERAL] a couple questions about convert()

On 09/19/2014 08:50 AM, Tom Lane wrote: > smcg2...@frii.com writes: >> In a postgresql-9.3.1 database with UTF8 encoding I can do: > >> select convert_from (E'\\x68656c6c6f', 'LATIN1'); >>convert_from >> -- >>hello > >> But when I explicitly give the "to" encoding: > >>

[GENERAL] a couple questions about convert()

Hello, In a postgresql-9.3.1 database with UTF8 encoding I can do: select convert_from (E'\\x68656c6c6f', 'LATIN1'); convert_from -- hello But when I explicitly give the "to" encoding: select convert (E'\\x68656c6c6f', 'LATIN1', 'UTF8'); convert -