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

Karen Springer wrote:
> 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.

Huh, maybe using the real source encoding instead?  Try, for example,
using Latin-1.

--
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.