On Mon, 2005-11-28 at 18:39, Stock, Stuart wrote: > FYI in case you still have the problem after using pg_dump from 8.1 (we did) > you may have an encoding mismatch between your 7.3 and 8.1 databases. Our > 7.x database was SQL_ASCII while 8.1 defaults to creating databases as > UTF-8. I had similar "invalid UTF-8 byte sequence" errors. I fixed it by > using: > > createdb --encoding=SQL_ASCII [your db here] > > When creating the database in 8.1. We were then able to load without a > problem. > > Not sure you're in the exact same situation, but hope it helps. Also, lookup the command iconv. VERY useful. I found out about it from this list, and use it for plenty other things than just postgresql.
