i have two machines, one with postgres 7.2.X and one with 7.3. Both their encodings are set to UNICODE. on the first i have crated a unicode database, with german, swedish and english texts, more to come. on that machine i dump the db with pg_dump -c -s ncg and pg_dump -D -a ncg. on that machine i can restore the structure and data of the database just fine.
I also edit the dump to use the coziness of my texteditor to add larger amounts of text. i can restore those edited dumps just fine. then i try to restore that database on the postgres 7.3. since i get errors like ERROR: Invalid UNICODE character sequence found (0xe4636b) whenever a german or swedish special char occurs, i insert an \ecoding LATIN1 before the critical sections. then i can restore the complete database, with the difference that the special characters are garbage: รถ and similar. How can i dump unicode databases to asci so that they are restored as unicode? i would like to edit the dump, as explained above. or How can i restore the database with its special chars in tact? ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
