displaying text from mysql database in Filemaker 9/10
I'm using Filemaker 9 and now 10 to display text fields from a mysql database (as an External data source). I'm finding that special characters like curly or smart quotes and trademark symbols don't display properly in the Filemaker fields. However, they are being stored properly, because I can copy the sql data to a Filemaker field using the "Set Field" command, copy it back the same way, and the text still displays correctly on the web.
Any ideas of what I need to do to get it to show up properly on the Filemaker side?
BTW I'm using the Helvetica font in my layout. I know it contains the curly quotes because I can type them into my fields when I use the "smart quotes" file option.