Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 7485A2E00FF for ; Mon, 10 Mar 2008 15:58:38 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 86198-01-5 for ; Mon, 10 Mar 2008 15:58:27 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from ug-out-1314.google.com (ug-out-1314.google.com [66.249.92.174]) by postgresql.org (Postfix) with ESMTP id F13B42E01B4 for ; Mon, 10 Mar 2008 15:58:19 -0300 (ADT) Received: by ug-out-1314.google.com with SMTP id j3so4280751ugf.49 for ; Mon, 10 Mar 2008 11:58:18 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; bh=ddVMI5y0xW/qbbv9E36cGzTlM66btyP7XXqTCY+ZR0A=; b=t/Vb+DnVVE8fSSAtSVQeaqfWD9Ap6DjYzIS0v/YhkZhR269dcXXpKvPKWsWYtdYjw/QkQ3u8lqyR5WIgUwnJNzOwnIEfXZkvpPJqHgy2HqrhsIaQuewdj/Ak95RrabJ8Fjrrq/JeKDSDjLUdE9+MRK8fIqMv5UfCcu44vaghmp8= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=LwS0I9lZ6j+meXAl+rIiCPRnfXa4oMGSm+UkuYrrjgyGQ7G8DVO6P24uBAUaa4Kt8fWaPrKquCmooVASVnYhiF5GKlZt6isJlGn2wT/tpU84zbzYjnwCHbZcLBzUx9zIv5ySsVXIFYrafYg4HUffvVvZcEKWTh4j6Zjm5SQN61Y= Received: by 10.142.222.21 with SMTP id u21mr2117314wfg.128.1205175497158; Mon, 10 Mar 2008 11:58:17 -0700 (PDT) Received: by 10.114.199.20 with HTTP; Mon, 10 Mar 2008 11:58:17 -0700 (PDT) Message-ID: <4544e0330803101158j2010f360qd487defd60bd9d9a@mail.gmail.com> Date: Mon, 10 Mar 2008 13:58:17 -0500 From: "Peter Koczan" To: "Mark Steben" Subject: Re: Newly converted to 8.2.5 and getting this error Cc: pgsql-admin@postgresql.org In-Reply-To: <004c01c882bc$d2e16af0$14010a0a@dei26g028575> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <004c01c882bc$d2e16af0$14010a0a@dei26g028575> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200803/78 X-Sequence-Number: 28561 On Mon, Mar 10, 2008 at 9:41 AM, Mark Steben wrote: > We have an application that cuts and pastes from Word and is getting this > error now that we have converted to 8.2.5. > > The characters that are erroring are imbedded in the document. We would > prefer not having to remove them > > ... > > Our client_encoding is obviously set at UTF8. Is there a client_encoding > value that is less restrictive? http://www.postgresql.org/docs/8.2/static/multibyte.html SQL_ASCII is less restrictive in that it will do no character conversion or checking. It comes with many caveats (read the above page). I think it also matters what the database on the server side is expecting. I don't think you can insert invalid Unicode into a UTF8 database, even if your client encoding is SQL_ASCII. It might try its best to convert the data, but don't quote me on that. If you really want to insert everything and don't care if it's valid UTF8 or not, create the database with the SQL_ASCII encoding. If you'd like there to be some semblance of checking, you'll have to think of some other solution. Peter