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
I had the same problem last week. iconv cleaned up my dump file, but
removed characters I actually wanted (degree & micro symbols). I tried
changing the encoding to Latin1 in my pg_dumpall file. This did seem to
help some, though there was still a problem with some of the characters.
I fina
thers? Java?
AJAX? PHP? Any suggestions would be much appreciated. We don't mind
something with a learning curve. We use open source where we can
(Fedora, Postgres, Bugzilla), but could probably talk management into
spending money for a good solution.
--
Karen Springer
-
