Re: Encoding-related errors when moving from 7.3 to 8.0.1

On Sat, Mar 19, 2005 at 05:25:46PM -0500, Carlos Moreno wrote:

Carlos,

> The error reads like:
>
> psql:db_backup.sql:1548: ERROR:  invalid byte sequence for encoding
> "UNICODE": 0xe12020
> CONTEXT:  COPY country, line 5, column namespanish:
> "Canad?                        "

Hmm.  The sequence looks like latin1 interpreted as utf8.  This seems
the inverse of the problem reported (and solved) here

http://archives.postgresql.org/pgsql-es-ayuda/2005-03/msg00491.php

Maybe you should try sticking a

SET client_encoding TO latin1;

at the beggining of the dump file.

Why are you using CHAR(n) fields anyway?  It should probably be better
if you used VARCHAR(n) ...

--
Alvaro Herrera (<alvherre[@]dcc.uchile.cl>)
"El destino baraja y nosotros jugamos" (A. Schopenhauer)