Parsing special characters for website?

[HALBURN]

I have a Filemaker solution that is pushing website content via an ODBC connection to a MySQL database. I have a bunch of special characters that are not showing up correctly on the website. I am trying to use the substitute function but it’s a mess. I am also have trouble parsing quote marks.

What is the best way to parse something like this?

Here are some example of what I am trying to parse:

> bullet: •

> apostrophe: ’

> open quote: “

> close quote: ”

> accent marks: é

parse to

> bullet: •

> apostrophe: ’

> open quote: “

> close quote: ”

> accent Marks: ???

[HALBURN]

Here is another example:

I am entering this: Chicken Molé Tacos

This is what shows up on my web page: Chicken Mol� Tacos