From: Peter Koczan <pjkoczan@gmail.com>
To: Mark Steben <msteben@autorevenue.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: Newly converted to 8.2.5 and getting this error
Date: Mon, 10 Mar 2008 13:58:17 -0500
Message-ID: <4544e0330803101158j2010f360qd487defd60bd9d9a@mail.gmail.com> (raw)
In-Reply-To: <004c01c882bc$d2e16af0$14010a0a@dei26g028575>
References: <004c01c882bc$d2e16af0$14010a0a@dei26g028575>
On Mon, Mar 10, 2008 at 9:41 AM, Mark Steben <msteben@autorevenue.com> 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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: pjkoczan@gmail.com, msteben@autorevenue.com
Subject: Re: Newly converted to 8.2.5 and getting this error
In-Reply-To: <4544e0330803101158j2010f360qd487defd60bd9d9a@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox