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

From: Murtuza Zabuawala <murtuza(dot)zabuawala(at)enterprisedb(dot)com>
To: Erik Myllymaki <erik(dot)myllymaki(at)gmail(dot)com>
Cc: pgadmin-support(at)lists(dot)postgresql(dot)org
Subject: Re: ordinal not in range when downloading result set as CSV
Date: 2017-11-03 06:21:22
Message-ID: CAKKotZQT-Enmzicf=PdKzvbVa5WOxnbeyqG-Yu3Wdp6VkonwEw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

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

You can report this issue here
<https://redmine.postgresql.org/projects/pgadmin4/issues>, 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(dot)myllymaki(at)gmail(dot)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
>

In response to

Browse pgadmin-support by date

  From Date Subject
Next Message Durumdara 2017-11-03 09:07:33 PGAdmin request: Drop object and Disconnect is too close to each other in local menu
Previous Message Richard Greenwood 2017-11-02 21:31:20 Re: F5 - irritating behaviour