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.
