Re: Encoding woes

"Bendik R.Johansen" <bendik.johansen@gmail.com> writes:
> I am having a few encoding related problems.

> 1. I have a database set up on my Mac OSX machine, PostgreSQL 8.02. I
> am trying to dump the tables and load them into Postgres on a Suse 9.2
> box. I get the following error:
> ERROR:  invalid byte sequence for encoding "UNICODE": 0xe5742c

I'm betting that the database encoding on the source machine was set as
SQL_ASCII, but that you then proceeded to store a lot of data that
wasn't plain ASCII.  To load it into a machine with a different database
encoding, you are going to have to be honest about what the data
actually is.  You should modify the dump file to set "client_encoding"
to the correct description of the source data (Latin1 maybe?).  Postgres
can translate Latin1 to Unicode ... but only if it's told what the data
encoding is.

            regards, tom lane