I am trying to read data from ORACLE using PANDAS:
pd.read_sql(sql, myORACLEinfo)
where sql is a select statement
I don't own the ORACLE table, nor I can make change to the table date.
The pd.read_sql
is returning this error:
refresh 'charmap' codec can't decode byte 0x81 in position 1101:
character maps to <undefined>
is there a way to escape/ignore this error.
I tried adding: encoding='iso-8859-1'
to the alchemy create_engine settings,
assuming ORACLE's default encoding is iso-8859-1
, but this did not help