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
This site is in read only mode. Please continue to browse, but replying, likes,
and other actions are disabled for now.
ERROS MSG: Error running query: ‘utf8’ codec can´t decode byte 0xa0 in position 7:invalid start byte
jesse
2
What version of Redash are you using? How did you install it? What kind of database are you connecting to?
lscapim
3
We are using Redash version: 8.0.2.b37747 OS: Windows Server 2016 Datacenter. Install in docker. Oracle.
jesse
4
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.