Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1f0vW3-0004j0-9v for pgsql-general@arkaria.postgresql.org; Tue, 27 Mar 2018 20:48:23 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1f0vW2-0000pp-5H for pgsql-general@arkaria.postgresql.org; Tue, 27 Mar 2018 20:48:22 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1f0vW1-0000pf-QS for pgsql-general@lists.postgresql.org; Tue, 27 Mar 2018 20:48:21 +0000 Received: from mail-it0-x231.google.com ([2607:f8b0:4001:c0b::231]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1f0vVz-0008IW-8l for pgsql-general@postgresql.org; Tue, 27 Mar 2018 20:48:20 +0000 Received: by mail-it0-x231.google.com with SMTP id p67-v6so910503itc.2 for ; Tue, 27 Mar 2018 13:48:19 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=from:content-transfer-encoding:mime-version:subject:message-id:date :to; bh=Wmf3afdGpRI1WIKcg2C2+tLkmGYCTa5CYue8OiCaABM=; b=TFbGHIIbQMGFYL/44lGsmo/Bu2mKJ2uErRO3RliY/SIvjpTMlZIl1GFlKHifABl5jR V10JD8bCBY3yOtPjKJEwP24+Gfp7KlwTzapA6lqAVg5uPkgJ756bBjKO7O3SZgsRqZRa loFQ9mqDJ+urTbZWBC/VSoIRCvEDXXssd64f3gfhfPOfq8C+kSlOCH9WKaFsRmc+vQXw T5wqDG+9qXlYspgJdSLSJwPk6jqvp8STfuP1195us9wphV6y35+hCo4Syv2UcwPYMrwI wumAVXiI+7mHrKouROdzLW+IfUu4n8ya1KUbCqpAYRd7VKdkMeZovSdxlESWjQ5lFu6a GTPw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:from:content-transfer-encoding:mime-version :subject:message-id:date:to; bh=Wmf3afdGpRI1WIKcg2C2+tLkmGYCTa5CYue8OiCaABM=; b=iH0wXKM50PNUz3GC6R9uYC/+hLqwZ9SzWX029SgYIaF1X1IhueuQ5tY9hsUJiriJcG 6Q5zaOlTWvfOzLQm62W9cZbB4RTgvj0cXCGtzst4mRxQMR4Cz5n6KJV5iM8f1vNnU2ny FicqPQufBpUr+ifP5JIleyTNRIu8sEhLBRscE/TNlHBJgFL+g5EODKH4bYcDgxxY3t+i 3CK8ZOxo0TtEAj/kBiwFPg1qDOvdCajp95OYOS7s2pe9LHpL0eVNd5luC0UVjnqjYcza Zy4AxIEsU+g+3tmsV+0C1mc5rsqTiG4zzF14OAs5PmHukasgYV/D9gsEboFvYHjywhRt RtQg== X-Gm-Message-State: AElRT7GYJb25sYiFq7JbGgcbyilKiEk/lncLMJK3AsgaKpsicgH/ZaZB bTB94Uyfm4IUOo0XDDPjg83BawMF X-Google-Smtp-Source: AIpwx4+7bm0OqYs0siXYmt/GXGSqdX1OuVMY3XWCPDtGk+QqmiMEg2AiIzqkcTPw9lyDlHwEcDyO3A== X-Received: by 2002:a24:49a3:: with SMTP id e35-v6mr887281itd.114.1522183698281; Tue, 27 Mar 2018 13:48:18 -0700 (PDT) Received: from ?IPv6:2605:a601:2062:d00:edc6:3403:5c7a:2508? ([2605:a601:2062:d00:edc6:3403:5c7a:2508]) by smtp.gmail.com with ESMTPSA id d18sm1310967iob.77.2018.03.27.13.48.16 for (version=TLS1_2 cipher=ECDHE-RSA-AES128-GCM-SHA256 bits=128/128); Tue, 27 Mar 2018 13:48:17 -0700 (PDT) From: armand pirvu Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable Mime-Version: 1.0 (Mac OS X Mail 10.3 \(3273\)) Subject: ERROR: invalid byte sequence for encoding "UTF8": 0xfc Message-Id: Date: Tue, 27 Mar 2018 15:47:46 -0500 To: "pgsql-general@postgresql.org" X-Mailer: Apple Mail (2.3273) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk Folks =46rom 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=20 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 =E2=80=94 Armand