Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pYUOE-0007AB-Ug for pgsql-general@arkaria.postgresql.org; Sat, 04 Mar 2023 16:05:42 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pYUOC-0008P4-Eq for pgsql-general@arkaria.postgresql.org; Sat, 04 Mar 2023 16:05:40 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pYUOC-0008Ov-4D for pgsql-general@lists.postgresql.org; Sat, 04 Mar 2023 16:05:40 +0000 Received: from smtp.burggraben.net ([88.198.69.140]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pYUOA-00012d-13 for pgsql-general@lists.postgresql.org; Sat, 04 Mar 2023 16:05:39 +0000 Received: from elch.exwg.net (elch.exwg.net [IPv6:2001:470:7120:1:127b:44ff:fe4f:148d]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) (Client CN "elch.exwg.net", Issuer "R3" (not verified)) by smtp.burggraben.net (Postfix) with ESMTPS id 9B0F7C00311; Sat, 4 Mar 2023 17:05:36 +0100 (CET) Received: by elch.exwg.net (Postfix, from userid 1000) id 216D03AB07; Sat, 4 Mar 2023 17:05:36 +0100 (CET) Date: Sat, 4 Mar 2023 17:05:36 +0100 From: Christoph Moench-Tegeder To: Raivo Rebane Cc: pgsql-general@lists.postgresql.org Subject: Re: shp2pgsql error under windows Message-ID: References: MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Disposition: inline In-Reply-To: User-Agent: Mutt/2.2.9 (2022-11-12) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk ## Raivo Rebane (raivore55@gmail.com): > Raivo@DESKTOP-69FUU49 /cygdrive/f/3D-data/Kataster > > $ cat kataster.sql | less > > > > S^@E^@T^@ ^@C^@L^@I^@E^@N^@T^@_^@E^@N^@C^@O^@D^@I^@N^@G^@ ^@T^@O^@ That's a BOM and the rest looks like UTF-16 (or UCS-2). You can use recode (also available in Cygwin) to convert that. You could also use shp2pgsql in Cygwin and be done with that (Windows is a quite bloated bootloader for Cygwin, but you do you)). Regards, Christoph -- Spare Space