On Thu, Oct 14, 2010 at 1:37 PM, Samaraweera, Shaminda
> Here is the error message I get.
> ERROR: invalid byte sequence for encoding "UTF8": 0xc4c4
> CONTEXT: COPY master_admin, line 683
> The special characters starts at line 683.
That message is telling you that you're attempting to load in a file
via COPY, and that you have your client_encoding set to UTF8, but the
file wasn't created in UTF8 encoding. You need to figure out what
encoding that file is in, and then adjust client_encoding accordingly.
> Also not really sure how to configure the system locales.
> I just see C, English_United States.1252, and Posix.
> Can somebody guide me with reference to this.
I'm not sure I understand what other problems you're having, but in
case you haven't seen it already, this page explains how Postgres
handles character encodings (as well as the client_encoding setting):
In response to
pgsql-novice by date
|Next:||From: Bob McConnell||Date: 2010-10-17 13:03:52|
|Subject: Overriding local encoding defaults|
|Previous:||From: Francisco Leovey||Date: 2010-10-15 14:11:59|
|Subject: Re: pgstatspack reports output to file.|