On: Friday, July 04, 2003 6:46 PM "myself" wrote:
> Hi all,
> I have a DB ( postgres 7.3.3 ) with encoding SQL_ASCII and in
> some field I have strange character:
>
> # \encoding
> SQL_ASCII
> # select city, id_country from user_data where id_user = 4146;
> city | id_country
> ---------------------------+------------
> Serra de Outes - A Coruña | 61
> (1 row)
>
>
> now if I do a dump the line relative to this row is truncated and
> after the field city field id_country is not dumped!!!
> I tried to use the pg_dump of Postgres 7.3.2 and I have the same
> error :-(
> BTW I'm without backup
I solved my problem exporting PGCLIENTENCODING=latin-1
I was running Postgres7.3.2 till few days ago without problems.
Regards
Gaetano Mendola