From: Steve Crawford <scrawford@pinpointresearch.com>
To: Matt Williams <matt@williams-tech.net>
Cc: pgsql-admin@postgresql.org
Subject: Re: utf8 database not dumping utf8 characters
Date: Fri, 06 Apr 2012 15:19:27 -0700
Message-ID: <4F7F6BEF.6010007@pinpointresearch.com> (raw)
In-Reply-To: <2F1A03239AE84E5F8217570AE41AA4C4@williams-tech.net>
References: <5D15382C1CF943D8A7B69D102A2BCBD4@williams-tech.net>
<4F7F4C2E.7050007@pinpointresearch.com>
<2F1A03239AE84E5F8217570AE41AA4C4@williams-tech.net>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: scrawford@pinpointresearch.com, matt@williams-tech.net
Subject: Re: utf8 database not dumping utf8 characters
In-Reply-To: <4F7F6BEF.6010007@pinpointresearch.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox