Re: Unicode "\uFEFF" getting copied from pgadmin 1.6 SQL window

FYI – uFEFF is the Unicode Byte Order mark, i.e. Big Endian vs Little Endian, that may optionally start any Unicode string. In my experience, I have found many builders of text editors treat optionally as meaning they can ignore it, when in fact they need to check for it and handle it correctly.

There are many search results resulting of said issue.
--
Michael Rasmussen
Sr. Data Engineer
Porch

From: "Barrington-Hughes, Alan" <Alan_Barrington-Hughes(at)PremierInc(dot)com>
Date: Thursday, September 7, 2017 at 8:06 AM
To: Murtuza Zabuawala <murtuza(dot)zabuawala(at)enterprisedb(dot)com>
Cc: "pgadmin-support(at)lists(dot)postgresql(dot)org" <pgadmin-support(at)lists(dot)postgresql(dot)org>
Subject: Re: Unicode "uFEFF" getting copied from pgadmin 1.6 SQL window

From what I can see in the IDE, everything is UTF-8.

Cheers, Alan

On Sep 7, 2017, at 12:46 AM, Murtuza Zabuawala <murtuza(dot)zabuawala(at)enterprisedb(dot)com<mailto:murtuza(dot)zabuawala(at)enterprisedb(dot)com>> wrote:

****This email did not originate from the Premier, Inc. network. Use caution when opening attachments or clicking on URLs.*****

.
I am unable to reproduce this issue on MacOS 10.10.5, I tested copy/paste with pgAdmin4 to pyCharm IDE/VSCode both works fine.
What type of encoding you have in your IDE?

On Thu, Sep 7, 2017 at 3:22 AM, Barrington-Hughes, Alan <Alan_Barrington-Hughes(at)premierinc(dot)com<mailto:Alan_Barrington-Hughes(at)premierinc(dot)com>> wrote:
We are experiencing a strange unicode character being copied over with text in pgadmin 1.6 (Mac OS 10.12.6

Here is the SQL window
<PastedGraphic-2.png>

And the pasted result in the development IDE:

<PastedGraphic-3.png>

Any thoughts on what could be causing this?

Cheers, Alan
--
Alan Barrington-Hughes
Software Architect
Premier, Inc. (NASDAQ: PINC)