invalid UTF-8 byte sequences and iconv

From: Karen Springer <karen(dot)springer(at)wulfsberg(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: invalid UTF-8 byte sequences and iconv
Date: 2006-07-25 19:04:19
Message-ID: 44C66B33.3070504@wulfsberg.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Alvaro Herrera 2006-07-25 19:29:37 Re: invalid UTF-8 byte sequences and iconv
Previous Message Samuel B. Quiring 2006-07-25 17:45:24 can't restore data\ folder