|[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]|
On Friday, April 6, 2012 at 4:03 PM, Steve Crawford wrote:
On 04/06/2012 12:55 PM, Matt Williams wrote: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.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?
--Matt WilliamsSent with Sparrow
[Postgresql General] [Postgresql Performance] [Postgresql PHP] [Postgresql Jobs] [PHP Users] [PHP Databases] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Databases] [Yosemite]