Search not displaying all matching rows

When using the search feature to look through a library of songs on my app, the search is not displaying all of the matching rows (song titles). This issues seems to only happen when an apostrophe is in the song title. As you can see in the screenshot below, when searching “Don,” the app pulls up everything including all tracks containing “Don’t” in the title. However, if the user types in the full search query of “Don’t,” the app will only display a few songs. Any reasoning for this? Nothing looks suspicious in my spreadsheet.

Your sheet contains "Don't" and "Don’t" — the first has a straight single quote and the second has a curled closing quote mark. These are distinct symbols. We will have to make Glide’s search a bit smarter to fix this.

1 Like

Thank you, David. To be completely honest, I didn’t even know that was a thing. The curled closing quote seems to be the only thing that the app will recognize.

Thanks for the quick response and help. You guys are awesome!