| From: | Alvaro Herrera <alvherre(at)commandprompt(dot)com> |
|---|---|
| To: | Karen Springer <karen(dot)springer(at)wulfsberg(dot)com> |
| Cc: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: invalid UTF-8 byte sequences and iconv |
| Date: | 2006-07-25 19:29:37 |
| Message-ID: | 20060725192937.GC21005@surnet.cl |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ivo Rossacher | 2006-07-25 19:58:47 | Re: invalid UTF-8 byte sequences and iconv |
| Previous Message | Karen Springer | 2006-07-25 19:04:19 | invalid UTF-8 byte sequences and iconv |