Re: Unicode "\uFEFF" getting copied from pgadmin 1.6 SQL window - Mailing list pgadmin-support

From Michael Rasmussen
Subject Re: Unicode "\uFEFF" getting copied from pgadmin 1.6 SQL window
Date
Msg-id AFF2870E-CA80-4421-8EA5-B82667D5F47D@porch.com
Whole thread Raw
In response to Re: Unicode "\uFEFF" getting copied from pgadmin 1.6 SQL window  ("Barrington-Hughes, Alan" <Alan_Barrington-Hughes@PremierInc.com>)
List pgadmin-support

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@PremierInc.com>
Date: Thursday, September 7, 2017 at 8:06 AM
To: Murtuza Zabuawala <murtuza.zabuawala@enterprisedb.com>
Cc: "pgadmin-support@lists.postgresql.org" <pgadmin-support@lists.postgresql.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.zabuawala@enterprisedb.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@premierinc.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)

 

 

pgadmin-support by date:

Previous
From: "Barrington-Hughes, Alan"
Date:
Subject: Re: Unicode "\uFEFF" getting copied from pgadmin 1.6 SQL window
Next
From: Murtuza Zabuawala
Date:
Subject: Re: Unicode "\uFEFF" getting copied from pgadmin 1.6 SQL window