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 (<[EMAIL PROTECTED]>) "El destino baraja y nosotros jugamos" (A. Schopenhauer) ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
