Re: utf8 database not dumping utf8 characters

On 04/06/2012 12:55 PM, Matt Williams wrote:
> I have a database that is utf8 and displays utf8 values correctly in
> psql. When dumped, it displays the utf8 characters incorrectly. ie. ö
> turns into Ã
>
> In the header of the dump file, I have:
>
> SET client_encoding = 'UTF8';
>
> So I'm not sure where the disconnect is?
>
> Thoughts?
>
> Thanks,
>
> --
> Matt Williams
> Sent with Sparrow <http://www.sparrowmailapp.com/?sig>
>
With what are you viewing the dump file and is everything in the chain
(terminal, less/vi/...) set to interpret/display that data as UTF8? You
can always use a hex-dump program to see the actual bytes in the file
and determine if they are what you expect for UTF8.

Cheers,
Steve