Repository navigation
Connection.getinfo(SQL_DATABASE_NAME) returns string with embedded NUL characters #762
Description
Describe the bug
Connection.getinfo(SQL_DATABASE_NAME) appears to decode the value using UTF-8 instead of UTF-16LE, causing embedded NUL (\x00) characters to appear between every character in the returned database name.
To reproduce
import mssql_python
from mssql_python.constants import GetInfoConstants
conn = mssql_python.connect("<connection string>")
database = conn.getinfo(
GetInfoConstants.SQL_DATABASE_NAME.value,
)
print(database)
print(repr(database))Expected behavior
print(repr(database)) should output the database name with no NUL characters.
Further technical details
Python version: 3.14
SQL Server version: Azure SQL MI
Operating system: Ubuntu 24.04 devcontainer on WSL
Additional context
Suspected Cause
In Connection.getinfo(), string-valued SQLGetInfo constants are decoded as UTF-16LE using the string_type_constants set.
SQL_DATABASE_NAME does not appear to be included in that set, so it falls through to the generic UTF-8 decoding path.
The set currently includes values such as:
GetInfoConstants.SQL_DATA_SOURCE_NAME.value
GetInfoConstants.SQL_DRIVER_NAME.value
GetInfoConstants.SQL_DRIVER_VER.value
GetInfoConstants.SQL_SERVER_NAME.value
GetInfoConstants.SQL_USER_NAME.valuebut appears to be missing:
GetInfoConstants.SQL_DATABASE_NAME.valueAdding SQL_DATABASE_NAME to the UTF-16LE string constants should make its behavior consistent with the other string-valued SQLGetInfo fields.
Activity
github-actions commentedon Sep 8, 2026
Hi jonahmdot, thank you for opening this issue!
Our team will review it shortly. We aim to triage all new issues within 24-48 hours and get back to you.
If you have additional information to share, please feel free to update the issue.
Thank you for your patience!
FIX: Decode SQL_DATABASE_NAME in Connection.getinfo() (#771)
bewithgaurav commentedon Sep 17, 2026
jonahmdot - this is live with v1.15.0, please upgrade your driver and let us know if you're facing any issues
thanks for raising this.. :)