Hello, I want to convert an existing database with SQL_ASCII encoding to UNICODE encoding.
(postgresql ver 7.3.2) I thought that it might be as easy as: pg_dump mydatabase > dump.sql createdb --encoding=unicode newdatabase psql newdatabase < dump.sql but it wasn't going to be that easy now was it :-( I'm getting errors such as: ERROR: copy: line 54, Invalid UNICODE character sequence found (0xe46765) lost synchronization with server, resetting connection Can anyone suggest a way I might be able to do it? Thanks, David http://search.yahoo.com.au - Yahoo! Search - Looking for more? Try the new Yahoo! Search ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
