Re: No UTF8 in LC_COLLATE

On Thu, Oct 14, 2010 at 1:37 PM, Samaraweera, Shaminda
<shaminda.samaraweera@navteq.com> wrote:
> 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):
<http://www.postgresql.org/docs/current/static/multibyte.html>

Josh