how you change the encoding or collation depends on the tool you use to manage your mySQL database. I am including a screen shot showing how to change those settings using SequalPro.
another thing to check is the data in the tabel directly. Does the apostrophe apear correct in the database?