Re: How do I change the server encoding? - Mailing list pgsql-general

From Joseph Shraibman
Subject Re: How do I change the server encoding?
Date
Msg-id b3h4hs$197v$1@news.hub.org
Whole thread Raw
In response to Re: How do I change the server encoding?  (Peter Eisentraut <peter_e@gmx.net>)
Responses Re: How do I change the server encoding?
Re: How do I change the server encoding?
List pgsql-general
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.


pgsql-general by date:

Previous
From: Hadley Willan
Date:
Subject: Re: Why are absolute paths considered a security risk?
Next
From: Joseph Shraibman
Date:
Subject: Re: How do I change the server encoding?