Mysql Search Problem Unicode Spaces?

[Walin]

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

[slavic]

You don't indicate the environment you are using to query the database (web form? command line? GUI of some sort?) so it's difficult to guess where the problem lies.

The best advice I could give you is to use FULLTEXT searching.

http://dev.mysql.com/doc/refman/5.0/en/fulltext-search.html