Philippe Kiener writes:
> My database should be transform from SQL_ASCII to utf-8
>
> I have added that line to my dumps:
>
> SET CLIENT_ENCODING TO 'SQL_ASCII';
>
> Now when I load the dump into my db, I get that error on tables with text:
>
> psql:tcom-database.sql:7111: ERROR: copy: line 1, Invalid UNICODE character
> sequence found (0xe96500)
The client encoding SQL_ASCII means that the data will be passed through
unchanged. Try setting it to LATIN1.
--
Peter Eisentraut peter_e@gmx.net