To use a Unicode character set in SQL, specify the character set when creating or altering a database, table, or column. For example, you can use "UTF8" or "UTF16" to indicate Unicode encoding.

As you can see, the final "r" is dropped. For each extra emoji in the text, more characters seem to be truncated (N emoji = last N characters are dropped). This seems to happen when pyodbc is ...

OK. So, I inherited an ASP 3.0 web app that I just recently realized has a character encoding problem. Long story short, the data that users are submitting has started to become riddled with ...