Answered: Q2A search relevancy with accented language is ZERO
Post date: 2020-08-02 19:55:26
Views: 104
If you want to do an accent-sensitive MySQL query, you have to either modify the query with COLLATE parameters, or you have to change your database collation type.

The so-called Q2A simple search module is not as simple as its name says. It employs dozens of functions. The issue with Q2A is you don't know where to modify the SQL query with COLLATE attributes.

This forces me to use the other choice, which is changing the database collation type. For those who have the same interest, the keyword is utf8_bin.
Please click Here to read the full story.
 
Other Top and Latest Questions:
Emirates CEO issues apology after Dubai flood chaos; says airline has 30,000 suitcases to return
Global military spending hit all-time high in 2023 after 7% jump, report finds
Certified Addiction Counselor work experience conundrum
Charles Buhler reactionless drive math error?
I eat salmon, love it. What are other good-guy sources of fat?
Should I buy some facebook fixit car paint
Express files for bankruptcy, plans to close nearly 100 stores as investor group looks to save the brand
Ex-JetBlue CEO Robin Hayes to run Airbus North America
Informatica says it's not for sale, following Salesforce's reported interest in $10 billion deal
Verizon reports fewer quarterly subscriber losses on flexible plan demand