Q:

Encoding Issue Exporting from PostgreSQL

I've got a query I'm running and exporting the data from PostgreSQL.  I'm ending up with a ton of Â characters in place of apostrophes and such when I open it in Wordpad or Excel.  Quite frankly, I can't get my ahead around any of this encoding crap.   How when I'm exporting the data do I get those characters to show right?

A:

I followed the instructions here and it did it. Thanks everyone anyway.
http://www.wohill.com/a-workaround-for-encoding-problems-in-excel/

