Last week, when doing integration test with another team member, he mentioned that one row in the inbound table showed the invalid character. After looking into this interesting issue in our DB, here is the screenshot.
How could this issue happen?
If users are typing apostrophe in MS Word or Outlook, it shows the first one above (Curly quote or Smart quote) by default.
Usually users won't do it in this way. The best way is that we need to validate the data with Curly quote often in the DB.