Migrated issue, originally created by Anonymous When using convert_unicode=True, regular select returns unicode, but select distinct does not.

PR #4667 "fixed" issue #4622 by making all string literals Unicode in our SQL generation. But it has been claimed that SQL Server cannot leverage indexes when comparing a Unicode literal or parameter ...

Learn how to store and manipulate data from different languages, scripts, or symbols using a Unicode character set in SQL, and avoid common pitfalls.