Funky characters in imported posts: ?

Hi,
I have a lot of posts / blogs that now show ? instead of what I believe for the most part should just be ' apostrophes. Is there a way to see which table the individual blogs are in so I can see what these characters are supposed to be. Or have you come across this before and possibly have a script I could run to search and replace in all posts network wide?
Thanks