| From: | armand pirvu <armand(dot)pirvu(at)gmail(dot)com> |
|---|---|
| To: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | ERROR: invalid byte sequence for encoding "UTF8": 0xfc |
| Date: | 2018-03-27 20:47:46 |
| Message-ID: | B64A85D2-A896-4050-92F2-700836B3C0CA@gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tim Cross | 2018-03-27 20:56:40 | Re: Postgresql 9.3 Server will not start after Ubuntu Upgrade |
| Previous Message | Ken Beck | 2018-03-27 20:46:24 | Re: Postgresql 9.3 Server will not start after Ubuntu Upgrade |