When I try to connect to oracle with Python3.7 sqlalchemy, I get the following error. It seems that cx_Oracle alone can connect to oracle, so I didn't understand what caused it.
I couldn't get to the information easily Since encoding and charset have taken a long detour, I will describe them.
reference) http://blog.kzfmix.com/entry/1361525164
UnicodeDecodeError: 'utf-8' codec can't decode byte 0x98 in position 11: invalid start byte
The error was resolved by embedding the following in the py source.
import os
os.environ["NLS_LANG"] = "JAPANESE_JAPAN.AL32UTF8"
Recommended Posts