Re: Going from a DB using SQL_ASCII to UNICODE

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.