Skip to content

ASCII codec encoding error #4

@gworley3

Description

@gworley3

I'm seeing the following error when trying to select from one of my foreign tables (we have data stored in UTF-8):

postgres=# select * from remote_companies limit 1;
ERROR:  Error in python: UnicodeEncodeError
DETAIL:  'ascii' codec can't encode character u'\xe4' in position 69: ordinal not in range(128)

I already tried switching Postgres to UTF8 (recreated the database to use UTF8 encoding and en_US.UTF8 locale and made sure client_encoding is set to UTF8) but didn't resolve it, so seems to be happening in the Python code.

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions