Thank you for your post.
My gut feeling is that the curly/smart quotes in FileMaker Pro are different from the curly/smart quotes in mySQL. I would type a curly quote into a test field (Field1), and then paste a curly quote from mySQL into a second test field (Field2). In FileMaker Pro 10, one of the new calculation functions is Code (), which returns the Unicode/ASCII code for a character. Therefore, create a calculation field, CALC, with the formula:
Code (Field1) & " " & Code (Field2)
This will let us know if the codes are identical or not. You may want to do the same with the trademark symbol, too.
Thanks for the suggestion TSGal. I was able to get some clarification on this from Actual Technologies, maker of the ODBC driver. My mysql database uses the latin-1 character set, and Filemaker is using UTF-16. So you are right about the symbols being different. We are upgrading our mysql db anyway, so once its changed to UTF-8 things should work properly again.