Funky character in my database

[rakennedy75]

Recently I imported a text file in my database and it had a funky character that carried over. I believe the character signify's a empty character or a space of some sort. It is in the shape of a square. I have seen it before but i am not sure exactly sure where it comes from. This is populating in my database and it is very ugly. I am pulling the column called details and I put a trim funciton on it. This worked on the ends of the string. In some of the strings the character is in the middle of the string so obviously the trim won't work. I thought of doing a character replace but I don't know how to duplicate the character since it represents a space. Any ideas or thoughts on how to accomplish this?

Thanks for your time

[sijis]

you're talking about one of these characters, right? 

try this....

copy the square (edit > copy if on windows)
then do something like
$db_output = str_replace('<goofy character>', '', $db_output);

just to be safe, create another file and simulate the output.

replace <goofy character> with edit > paste (if on windows).

here's what i mean.

$text = 'this is that goofy, character, darn';

$text = str_replace('', '', $text);

echo $text;

// output should be
// this is that goofy, character, darn

hope that works.

sijis