Thread: No UTF8 in LC_COLLATE
Hi ,
I’m creating a new database of encoding “UTF8”.
When I try to Collocate to “UTF8” I find that its not there.
I tried to sql out the query and use “en_US.UTF-8” or “en_US.utf8” but nothing seems to be working.
My data will have English and Russian and many other language characters.
Please advice on how to get the UTF8 collocate working.
Thanks
The information contained in this communication may be CONFIDENTIAL and is intended only for the use of the recipient(s) named above. If you are not the intended recipient, you are hereby notified that any dissemination, distribution, or copying of this communication, or any of its contents, is strictly prohibited. If you have received this communication in error, please notify the sender and delete/destroy the original message and any copy of it from your computer or paper files.
On Donnerstag, 14. Oktober 2010, Samaraweera, Shaminda wrote: > but nothing seems to be working. What did you exactly do, what do you want to achive and what was the error message? Make shure, that your system locales are configured. Rgds, Jens
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. 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. Thanks -----Original Message----- From: pgsql-novice-owner@postgresql.org [mailto:pgsql-novice-owner@postgresql.org] On Behalf Of Jens Wilke Sent: Thursday, October 14, 2010 12:22 PM To: pgsql-novice@postgresql.org Subject: Re: [NOVICE] No UTF8 in LC_COLLATE On Donnerstag, 14. Oktober 2010, Samaraweera, Shaminda wrote: > but nothing seems to be working. What did you exactly do, what do you want to achive and what was the error message? Make shure, that your system locales are configured. Rgds, Jens -- Sent via pgsql-novice mailing list (pgsql-novice@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-novice The information contained in this communication may be CONFIDENTIAL and is intended only for the use of the recipient(s)named above. If you are not the intended recipient, you are hereby notified that any dissemination, distribution,or copying of this communication, or any of its contents, is strictly prohibited. If you have received thiscommunication in error, please notify the sender and delete/destroy the original message and any copy of it from yourcomputer or paper files.
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