Received: from malur.postgresql.org ([2a02:16a8:dc51::56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1ffMyg-00057K-Eg for pgsql-admin@arkaria.postgresql.org; Tue, 17 Jul 2018 10:13:06 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1ffMye-0001sg-PE for pgsql-admin@arkaria.postgresql.org; Tue, 17 Jul 2018 10:13:04 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1ffMye-0001sV-Hr; Tue, 17 Jul 2018 10:13:04 +0000 Received: from smtp.burggraben.net ([2a01:4f8:140:50a2::3:1]) by magus.postgresql.org with esmtps (TLS1.0:DHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1ffMyU-0003Z1-Mi; Tue, 17 Jul 2018 10:13:01 +0000 Received: from localhost (localhost [127.0.0.1]) by smtp.burggraben.net (Postfix) with ESMTP id 9F2846002EE; Tue, 17 Jul 2018 12:12:52 +0200 (CEST) X-Spam-Scanned: by amavisd-new at exwg.net Received: from smtp.burggraben.net ([127.0.0.1]) by localhost (ns.burggraben.net [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 6eBou+wn++wi; Tue, 17 Jul 2018 12:12:47 +0200 (CEST) Received: from elch.exwg.net (elch.exwg.net [IPv6:2001:470:7120:1:127b:44ff:fe4f:148d]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (Client CN "elch.exwg.net", Issuer "Christoph Moench-Tegeder" (verified OK)) by smtp.burggraben.net (Postfix) with ESMTPS; Tue, 17 Jul 2018 12:12:47 +0200 (CEST) Received: by elch.exwg.net (Postfix, from userid 1000) id 3A57827339; Tue, 17 Jul 2018 12:12:47 +0200 (CEST) Date: Tue, 17 Jul 2018 12:12:47 +0200 From: Christoph Moench-Tegeder To: ramsiddu007 Cc: pgsql-admin@lists.postgresql.org, pgsql-hackers@lists.postgresql.org, Monalee Bhandge Subject: Re: 65279 Invisible ASCII Character Message-ID: <20180717101246.GA41457@elch.exwg.net> Reply-To: pgsql-general@postgresql.org References: MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Disposition: inline In-Reply-To: User-Agent: Mutt/1.10.0 (2018-05-17) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk ## ramsiddu007 (ramsiddu007@gmail.com): > If i remove first character it's run. That first > character is invisible, I have checked that *ascii* value, it is *65279*. That's not an ASCII-value, ASCII has 8 bits at most. What you've got there is a UTF-16 Byte Order Mark: 65279 is 0xfeff (one of the well-known constants). I'd suggest you get your editor configured to write files without BOM. Maybe there's a workaround via locale settings - but I have no machine with an UTF-16 locale available. Another approach is using recode on your files before concatenating. This question isn't really for pgsql-hackers - I'm redirecting to -general. Regards, Christoph -- Spare Space