X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 6C2149DCA2C for ; Mon, 20 Mar 2006 19:04:50 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 96185-09 for ; Mon, 20 Mar 2006 19:04:52 -0400 (AST) X-Greylist: delayed 00:07:29.378639 by SQLgrey- Received: from coe.tamu.edu (edsun.coe.tamu.edu [165.91.232.6]) by postgresql.org (Postfix) with ESMTP id 066C29DC941 for ; Mon, 20 Mar 2006 19:04:47 -0400 (AST) Received: (from root@localhost) by bruner.coe.tamu.edu (8.13.1/8.13.1) id k2KMQsTX024712 for pgsql-admin@postgresql.org; Mon, 20 Mar 2006 16:26:54 -0600 Received: from coe.tamu.edu (coe.tamu.edu [165.91.232.6]) by coe.tamu.edu (8.11.7p1+Sun/8.12.11) with ESMTP id k2KMuvB23106 for ; Mon, 20 Mar 2006 16:56:57 -0600 (CST) Date: Mon, 20 Mar 2006 16:56:57 -0600 (CST) From: "Ben K." To: pgsql-admin@postgresql.org Subject: encoding question Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII; format=flowed X-Virus-Scanned: by AMaViS 0.3.12 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.12 required=5 tests=[AWL=0.120] X-Spam-Score: 0.12 X-Spam-Level: X-Archive-Number: 200603/185 X-Sequence-Number: 20942 Hi, My main server is on Solaris (LANG=C), postgresql 8.1.0, with encoding SQL_ASCII. I'm trying to set up a backup server on linux (LANG=en_US.UTF-8), with encoding UTF8. I thought UTF8 was safe if all I have is ascii, since there was a relevant discussion in this list a short while ago, but I'm getting this error, for a few records (out of tens of thousands in that database). =============== ERROR: invalid UTF-8 byte sequence detected near byte 0x85 CONTEXT: COPY tblcoursesinfo, line 30, column title: "Seminar in<85> ..." =============== The dump was created by 8.1.0's pg_dump with no options. That line in the dump has the following contents. Text: n<85> Knowledg Binary: 02e2100: 6e85 2020 2020 2020 2020 2020 2020 2020 n. 02e2110: 2020 2020 2020 2020 2020 2020 2020 2020 02e2120: 2020 2020 2020 2020 2020 2020 2020 2020 02e2130: 2020 2020 2020 2020 2020 2020 2020 2020 02e2140: 2020 2020 2020 2020 2020 2020 2020 2020 02e2150: 2020 2020 2020 2020 2020 2020 2020 2020 02e2160: 2020 2020 2020 2020 2020 2020 2020 2020 02e2170: 2020 2020 2020 2009 4b6e 6f77 6c65 6467 .Knowledg Where could this be coming from? Would appreciate help. Regards, Ben K. Developer http://benix.tamu.edu