Re: How do I change the server encoding?

Peter Eisentraut wrote:
> 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.
>
I tried with latin1 and it didn't work.