Am Dienstag, 20. April 2004 07:05 schrieb Frank Finner: > I answered to a similiar problem on the [GENERAL] list a few days ago. In > short: You can use "recode" in a pipe between dump and restore like > "pg_dump database|recode ascii..utf8|psql newdatabase" to get rid of > unicode problems while transferring from a different encoding. Please look > at my statements on the[GENERAL] list for the gory details.
This is not necessary. You just need to set the client encoding correctly (not SQL_ASCII, but something like LATIN1). The encoding conversion happens automatically, as usual. ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org