Jeff Davis wrote:
> On Wed, 2008-06-11 at 11:07 -0700, Jeff Davis wrote:
>> If the encoding is the same everywhere, and you are using PostgreSQL
>> 8.2, it's likely that you got an invalid byte sequence in a text field
>> by using backslash-escapes.
> 
> I see you're using 8.3, where this problem should be fixed. Are you sure
> that it's 8.3 everywhere, and the same encoding/locale everywhere?

I definitely seem some issues with encoding, and from what I see, 
there's database and client encoding.  The database encoding is 
different, but I've not figured out where that is configured, assuming 
it should be in the postgresql.conf file somewhere.  It appears that the 
client_encoding is different as well, although I would have expected 
that to have been taken care when the databases were built.  I have 
explicitly set the client_encoding in the postgresql.conf file, but 
haven't found where to set the database encoding.

-- 
Until later, Geoffrey

Those who would give up essential Liberty, to purchase a little
temporary Safety, deserve neither Liberty nor Safety.
  - Benjamin Franklin