In SQL, when dealing with Unicode data, use the right data types like NVARCHAR or NCHAR. To insert Unicode data, add an N before strings like N'' to indicate it's Unicode.

# in MS SQL Server to store Unicode. char and varchar columns use a codepage # and unicode characters inserted into them are converted to the codepage. # If a conversion does not exist in the codepage ...

SQLAlchemy not sending Unicode non-latin characters ... In debugging it seems to send the characters back to the driver, but the profiled results in SQL Server indicates that its not passing through ...