Re: utf8 database not dumping utf8 characters

From: Steve Crawford <scrawford(at)pinpointresearch(dot)com>
To: Matt Williams <matt(at)williams-tech(dot)net>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: utf8 database not dumping utf8 characters
Date: 2012-04-06 22:19:27
Message-ID: 4F7F6BEF.6010007@pinpointresearch.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Matt Williams 2012-04-07 03:28:09 Re: utf8 database not dumping utf8 characters
Previous Message Matt Williams 2012-04-06 20:11:07 Re: utf8 database not dumping utf8 characters