pg.ddx.io  pgsql-general@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: armand pirvu <armand.pirvu@gmail.com>
To: pgsql-general@postgresql.org <pgsql-general@postgresql.org>
Subject: ERROR:  invalid byte sequence for encoding "UTF8": 0xfc
Date: Tue, 27 Mar 2018 15:47:46 -0500
Message-ID: <B64A85D2-A896-4050-92F2-700836B3C0CA@gmail.com> (raw)

Folks


From another system (non postgres) as data gets changed we collect in the form like below into a named pipe which is tailed into psql -U csidba -d repdb -hrephost

insert into foo (mydata) values ('{"mail_stop": "" , "city_id": "Garching bei M?nchen"}');

And got a failure 
ERROR:  invalid byte sequence for encoding "UTF8": 0xfc


insert into foo (mydata) values ('{"mail_stop": "" , "city_id": "Garching bei M?nchen"}');

Problem is said system to convert to UTF8 is nicely put a huge amount of effort and we don't have the resources anyway at this point


This is not a copy, just a tailed named pipe into psql

Is there any trick/way I can shove this data into Postgres ? I really don't care whether it read "Garching bei M?nchen" or "Garching bei Mfoonchen"



Thanks
— Armand






view thread (19+ messages)  latest in thread

Message-ID: <B64A85D2-A896-4050-92F2-700836B3C0CA@gmail.com>
Permalink:  ../B64A85D2-A896-4050-92F2-700836B3C0CA@gmail.com/
Also on:    postgresql.org/message-id/B64A85D2-A896-4050-92F2-700836B3C0CA@gmail.com

 · 

reply

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 from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-general@postgresql.org
  Cc: armand.pirvu@gmail.com
  Subject: Re: ERROR:  invalid byte sequence for encoding "UTF8": 0xfc
  In-Reply-To: <B64A85D2-A896-4050-92F2-700836B3C0CA@gmail.com>
  References: <B64A85D2-A896-4050-92F2-700836B3C0CA@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