Every query on a table with a name that has a special character returns an error

adp_asilva · September 17, 2021, 7:16pm

Every query on a table with a name that has a special character returns an error.

ERROS MSG: Error running query: ‘utf8’ codec can´t decode byte 0xa0 in position 7:invalid start byte

jesse · September 17, 2021, 9:19pm

What version of Redash are you using? How did you install it? What kind of database are you connecting to?

lscapim · January 14, 2022, 5:50pm

We are using Redash version: 8.0.2.b37747 OS: Windows Server 2016 Datacenter. Install in docker. Oracle.

jesse · January 18, 2022, 8:59pm

Thanks.

It sounds like this is a problem with how cx_oracle is returning data from your queries.

I found this link which discusses a similar issue. You can see if it’s possible to modify the settings on your Oracle database to return results in UTF8 format. Alternatively, it may be possible to modify the Redash source code in oracle.py to set the return format whenever Redash connects.