cursor.fetchall() cannot parse not utf-8 character

[KleinPan]

e = UnicodeDecodeError('utf-8', b'\xd0\xb4\xba\xc5PCBA-SN', 2, 3, 'invalid start byte')

conn.setdecoding(mssql_python.SQL_CHAR, encoding='gbk')
conn.setdecoding(mssql_python.SQL_WCHAR, encoding='gbk') not work!

[jahnvi480]

Thanks for raising this! To help me better understand the problem, could you please share:

• The complete code snippet where you’re trying to decode, calling the setdecoding() function and executing the query.
• The full error message/stack trace you are seeing.
  This will help me reproduce the issue on my end and provide a more accurate solution.

[KleinPan]

Code snippet：

建立数据库连接

    conn = mssql_python.connect(connection_string)

    # conn.setencoding(encoding=None, ctype=None)
    # Decode all CHAR/WCHAR data using UTF-8
    conn.setdecoding(mssql_python.SQL_CHAR, encoding='gbk')
    conn.setdecoding(mssql_python.SQL_WCHAR, encoding='gbk')
    print("数据库连接成功")

    # 创建游标
    cursor = conn.cursor()

    # 执行查询
    query = "select * from [TEST_WTMES].[dbo].[StatisticConfigure] where ComputerMAC = '2C:F0:5D:C5:D8:BF'"

    cursor.execute(query)

    # 获取查询结果
    rows = cursor.fetchall()

Error message:
UnicodeDecodeError('utf-8', b'\xd0\xb4\xba\xc5PCBA-SN', 2, 3, 'invalid start byte')
special variables
function variables
args =('utf-8', b'\xd0\xb4\xba\xc5PCBA-SN', 2, 3, 'invalid start byte')
encoding ='utf-8'
end =3
object =b'\xd0\xb4\xba\xc5PCBA-SN'
reason ='invalid start byte'
start =2

[KleinPan]

in fetchall the error line is below:
ret = ddbc_bindings.DDBCSQLFetchAll(self.hstmt, rows_data)

[sumitmsft]

Thanks @KleinPan for reporting this issue. We confirm that this is a bug and @jahnvi480 is working on fixing it. We will let you know once the fix is ready and released.

Thanks again.

[jahnvi480]

Thank you for your patience, @KleinPan
We’re actively investigating this issue. It’s a bit more involved, so it may take some time to resolve. While we don’t have an ETA at the moment, I’m working to get this addressed as quickly as possible. I’ll keep this thread updated as we make progress.