Message-ID: <4F7F6BEF.6010007@pinpointresearch.com>
Date: Fri, 06 Apr 2012 15:19:27 -0700
From: Steve Crawford <scrawford@pinpointresearch.com>
User-Agent: Mozilla/5.0 (X11; U; Linux x86_64; en-US;
	rv:1.9.2.27) Gecko/20120216 Lightning/1.0b2 Thunderbird/3.1.19
MIME-Version: 1.0
To: Matt Williams <matt@williams-tech.net>
CC: pgsql-admin@postgresql.org
Subject: Re: utf8 database not dumping utf8 characters
References: <5D15382C1CF943D8A7B69D102A2BCBD4@williams-tech.net>
	<4F7F4C2E.7050007@pinpointresearch.com>
	<2F1A03239AE84E5F8217570AE41AA4C4@williams-tech.net>
In-Reply-To: <2F1A03239AE84E5F8217570AE41AA4C4@williams-tech.net>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit

On 04/06/2012 01:10 PM, Matt Williams wrote:
> With that same dump file that is displaying incorrectly open in vim, I 
> can paste in the utf8 character I provided as an example and it 
> displays correctly.
I usually find a good first step is to run the file through something 
that will give you a hex dump (i.e. xxd or similar) and so I *know* the 
actual bytes in the file rather than relying on how they may be 
interpreted somewhere else along the chain. Find the hex-byte(s) of your 
suspect character and look it up.

Since you are in vim, it may be worth checking ":set termencoding", 
":set encoding" and ":set fileencoding".

Cheers,
Steve