mssql-python==1.8.0 fails with dlopen failed to resolve symbol.

[sam-leonard-ct]

Describe the bug

Importing mssql-python on macOS fails with

ImportError: dlopen(/Users/my_user/some_dir/.venv/lib/python3.12/site-packages/mssql_python/ddbc_bindings.cp312-universal2.so, 0x0002): symbol not found in flat namespace '__ZN7simdutf40convert_utf16le_to_utf8_with_replacementEPKDsmPc'

Which corresponds with this symbol:
_simdutf::convert_utf16le_to_utf8_with_replacement(char16_t const*, unsigned long, char*)

To reproduce

import mssql_python

Expected behavior

The symbol should be found and the library should load.

Further technical details

Python version: 3.12.11
SQL Server version: Doesn't matter
Operating system: MacOS 26.5.1
mssql-python: 1.8.0

mssql-python==1.7.1 does not exhibit this problem.

[sam-leonard-ct]

Checked in our Linux CI and it works fine.

[github-actions]

Hi @sam-leonard-ct, 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!

[gargsaumya]

Thank you @sam-leonard-ct for reporting this issue. The root cause for this bug was dynamic linking to simdutf, which can fail when the library is not available at the expected path.
This issue has already been fixed on the main branch in PR #608 . The fix ensures that simdutf is always statically linked, removing the external dependency and preventing this failure.

The fix will be included in our next release, thanks again for bringing this to our attention.