I am using Python 3.3 on Windows 7x64 machine to connect to an Oracle server over the VPN tunnel to dump locally data in a CSV file. I am using cx_Oracle module to connect to Oracle. Everything is fine until the cursor hits a character in some string column, which causes the module to fail with error:
for row in orcl_cur.execute(sql_select):
File "C:\Python33\lib\encodings\cp1252.py", line 15, in decode
UnicodeDecodeError: 'charmap' codec can't decode byte 0x8f in position 426: character maps to <undefined>
AT this point the dump stops to whatever rows were saved so far.
How can I avoid this?