Removing Characters in mysql that can't be read.

[cooldude832]

I have an old mysql table full of well ugly data. such as the following character

 

and so forth, is there any way I can extract all the ugly characters from the fields before inserting to mysql.

 

I have mysql_real_escape_string on all the incomming strings, but that didn't do it any ideas?

[cooldude832]

Is there a function that can tell all non readable characters?

[MadTechie]

unreadable character ??

you could filter to only allow what you want to keep,

to filter the VT try this

$data= preg_replace('/\x{0B}/i', '', $data);