Обсуждение: Unicode "\uFEFF" getting copied from pgadmin 1.6 SQL window

Поиск
Список
Период
Сортировка

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

От
"Barrington-Hughes, Alan"
Дата:
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

And the pasted result in the development IDE:


Any thoughts on what could be causing this?

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

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

От
Murtuza Zabuawala
Дата:
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

And the pasted result in the development IDE:


Any thoughts on what could be causing this?

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

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

От
"Barrington-Hughes, Alan"
Дата:
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)


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

От
Michael Rasmussen
Дата:

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)

 

 

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

От
Murtuza Zabuawala
Дата:
Hi,

I tested with almost all browsers in web mode on Mac and not able to re-produce the issue.

You might be facing the issue in runtime, I suspect that Qt WebEngine may be responsible for this behaviour (It sounds like CodeMirror's copy handler is somehow not running, and WebEngine's native copy behaviour is happening instead.)



--
Regards,
Murtuza Zabuawala
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

https://community.postgresrocks.net/

On Thu, Sep 7, 2017 at 8:36 PM, Barrington-Hughes, Alan <Alan_Barrington-Hughes@premierinc.com> wrote:
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)