OK tried that, made no difference. The strange thing is if i search for Mick the results page shows the results but the apostrophe is a black diamond. If i refresh the results page (in Firefox), the diamonds then display correctly as apostrophes.
Hmmmm.....just checked Internet Explorer and the apostrophes show as boxes on the results page and don't change when i refresh the page.
Checked the database and the records look correct, the doctype is:
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1" />
Also database collation set to latin1_swedish_ci