click
click
4 months ago (59,590 XP)
  • 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.

arecuk

so the space is actually: U+00A0 - no break space http://www.fontspace.com/unicode/analyzer/

Please sign in or create an account to participate in this conversation.