- Try http://www.fontspace.com/unicode/analyzer/ and paste it in there. Maybe it shows you want kind of character it is. It could be anything.
- I think there is no easy mysql update query to do a preg_replace function. So you could just run a simple select query. Detect the malformed ones and update them with the response of what
preg_replace('/[^a-zA-Z0-9]/','', $snp->rs_id) gives you.
- And to prevent this in the future you should strip all unwanted characters before you save the object:
$input = preg_replace('/[^a-zA-Z0-9]/','', $input)
I just opened your sql file and changed the character encoding of the file to something else. For windows-1250 it gives me:
Â rs1800795o it is definitely not a space.