Обсуждение: ordinal not in range when downloading result set as CSV

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

ordinal not in range when downloading result set as CSV

От
Erik Myllymaki
Дата:

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

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