Need advise on search please

Dear Flynax,

I just noticed that my site does not return results if there is difference in upper lower case. For example if listing has this text "Fairfax"
And I entered "fairfax" it will show no result.

Only enter exact "Fairfax" will show results. I must have messed something up. Would you please tell me which file should I looked into. So far, I looked at

Quote:

---

includes/classes/rlSearch.class.php

---

But found no problem, even replace with the original files from the fresh installation package. So I think there are other files that I should look into. But I don't know which, would you please point it out to me?

Thanks

Hello,

It seems that your mysql server is configured to be case-sensitive

because on our end it works fine

Quote:

---

Originally Posted by Rudi

Hello,

It seems that your mysql server is configured to be case-sensitive

because on our end it works fine

---

Dear Rudi,

Any clue where should I check to remedy this? Is it via phpmyadmin to mysql?

Hello Wei,

Try this: https://stackoverflow.com/questions/...ntire-database

Quote:

---

Originally Posted by Rudi

Hello Wei,

Try this: https://stackoverflow.com/questions/...ntire-database

---

Dear Rudi,

I had done some research and actually saw this page earlier but have no idea what to do? :(( Yes I sucks I know. Hu hu
Now I'm thinking may be the fix with emoji has effects on this? I'm not sure. Still scratching my head.