Search function does not like apostrophes?

[welshpixie]

Using BP1.1 and WP 2.8.4a

We have a setup on our site that will call for users to search on terms that include apostrophes, but this doesn't seem to be working.

For example - a few of our users have a profile field filled in as The Sha'Tar. Searching for this field including the apostrophe yields no results. Searching for The Shar, however, finds everyone who has The Sha'Tar in their profile.

Our site is encouraging networking and will rely on people being able to search on this particular field, which will eventually have more names with apostrophes in them.

Apologies if this has already been brought up - I couldn't find a ticket with it.

[welshpixie]

Sorry - that's searching on The Sha finds everyone, not The Shar :)

[apeatling]

Punting this as it's not an easy fix and will need more time.

[boonebgorges]

Paul, you probably already know this (thus #2776), but the problem here looks like double escaping - when I did addslashes( $search_terms ) in the get_users() method, I was able to get results.

[DJPaul]

This was fixed in [3511]), though searches may not work as intended until an underlying problem of double-escaping database content is addressed in #2776.