Thread: ordinal not in range when downloading result set as CSV

ordinal not in range when downloading result set as CSV

From
Erik Myllymaki
Date:

I"m trying to download the result set of a SQL query to csv and I get this error:

'ascii' codec can't encode character u'\ufeff' in position 33: ordinal not in range(128)

Any pointers appreciated, thanks.

This on Ubuntu 16.04:

Version
2.0
Copyright
Copyright 2013 - 2017, The pgAdmin Development Team
Python Version
2.7.12 (default, Nov 19 2016, 06:48:10) [GCC 5.4.0 20160609]
Flask Version
0.11.1
Application Mode
Desktop

Re: ordinal not in range when downloading result set as CSV

From
Murtuza Zabuawala
Date:
This issue occurs when you have some encoded data which pgAdmin4 can't decode while generating CSV file.

You can report this issue here, Please also include details to produce the issue​ (if possible also include some sample data), PG version (encoding details), Platform (encoding details) etc.

On Fri, Nov 3, 2017 at 2:04 AM, Erik Myllymaki <erik.myllymaki@gmail.com> wrote:

I"m trying to download the result set of a SQL query to csv and I get this error:

'ascii' codec can't encode character u'\ufeff' in position 33: ordinal not in range(128)

Any pointers appreciated, thanks.

This on Ubuntu 16.04:

Version
2.0
Copyright
Copyright 2013 - 2017, The pgAdmin Development Team
Python Version
2.7.12 (default, Nov 19 2016, 06:48:10) [GCC 5.4.0 20160609]
Flask Version
0.11.1
Application Mode
Desktop