Mysql Search Problem Unicode Spaces?

[musiq021]

I have a database setup with track names and titles for songs. When querying the database and using a standard space to seperate words, it doesn't return any results. For example, a search for 'Sammy Davis' yields no results, however, a search for 'Sammy', returns results with 'Sammy Davis'. So I copied and pasted the space in between 'Sammy' and 'Davis' from a row, and pasted it for my query, then it worked. My question is, are there seriously different kinds of spaces? Since that seems to be the case, how do I convert all the spaces in my DB to the right kind (the kind my spacebar generates).

Thanks for all your help, this one is stuuuuumping me big time.

-Sim

[powerdesign]

show your mysql query.
try you SELECT with REGEXP if u know what to do whit it