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