invalid UTF-8 byte sequences and iconv - Mailing list pgsql-admin

From Karen Springer
Subject invalid UTF-8 byte sequences and iconv
Date
Msg-id 44C66B33.3070504@wulfsberg.com
Whole thread Raw
Responses Re: invalid UTF-8 byte sequences and iconv
Re: invalid UTF-8 byte sequences and iconv
List pgsql-admin
Hi,

We have set up a new server and are needing to move our database from
7.3 to 8.1.4.  On restore I'm getting the 'invalid UTF-8 byte sequence'
error message.  If I use the command iconv -c -f UTF-8 -t UTF-8 -o
cleanfile.sql dumpfile.sql, then the characters are deleted and the
restore goes smoothly.  The problem is that we want those characters.
They are for example the degree symbol and the micro symbol.  Is there
anyway to bring these characters over?  Thanks in advance.

Karen

pgsql-admin by date:

Previous
From: "Samuel B. Quiring"
Date:
Subject: can't restore data\ folder
Next
From: Alvaro Herrera
Date:
Subject: Re: invalid UTF-8 byte sequences and iconv