Unwanted characters (–) in mysql records [solved]
Posted: Mon Sep 10, 2007 8:29 am
Hi there,
I have inherited a database which displays some funny characters when you echo the fields. In particular it seams to have placed – where a quote mark is meant to go and ’ in place of a apostrophe.
Does anyone have any ideas how I can clean this up. I've tried 'str_replace' and it's various alternates with no luck. I assume it is a character set problem on retrieval but that still doesn't leave me with any way of sorting the problem out.
All help will be greatly appreciated.
All the best
Steve
I have inherited a database which displays some funny characters when you echo the fields. In particular it seams to have placed – where a quote mark is meant to go and ’ in place of a apostrophe.
Does anyone have any ideas how I can clean this up. I've tried 'str_replace' and it's various alternates with no luck. I assume it is a character set problem on retrieval but that still doesn't leave me with any way of sorting the problem out.
All help will be greatly appreciated.
All the best
Steve