UnicodeDecodeError: 'utf-8' codec can't decode byte 0xfa in position 3: invalid start byte

[RamesChan]

trafficstars

Issue

This error happening when I try to run pyodbc create table in IBM Netezza Data warehouse.

root@7c04c45d49c2:/opt# python3 main.py Traceback (most recent call last): File "/opt/main.py", line 4, in conn = pyodbc.connect("DRIVER={NetezzaSQL};SERVER=192.168.xxx.xxx;DATABASE=MTDATABASE;PORT=5480;UID=admin;PWD=password")

UnicodeDecodeError: 'utf-8' codec can't decode byte 0xfa in position 3: invalid start byte

Python Script

import pyodbc

conn = pyodbc.connect("DRIVER={NetezzaSQL};SERVER=192.168.xxx.xxx;DATABASE=MTDATABASE;PORT=5480;UID=admin;PWD=password")
conn.setdecoding(pyodbc.SQL_CHAR, encoding='utf-8')
conn.setdecoding(pyodbc.SQL_WCHAR, encoding='utf-8')
conn.setdecoding(pyodbc.SQL_WMETADATA, encoding='utf-8')
conn.setencoding(encoding='utf-8')
cursor = conn.cursor()
cursor.execute("""CREATE TABLE PRODUCT (ID INT, NAME VARCHAR(50));""")
conn.commit()
conn.close()

Environment

• ubuntu:22.04
• python 3.12.6
• pyodbc==5.1.0