When I type in a different language other than English, I get this error "
Error: Illegal mix of collations for operation 'like'
Please, check the attachment for more details, thanks
Does this also happen when you open OpenEMR with the correct language? (Open with non-English) do the search with the same (non-English search string)
Yes, it happens even the used language is same for both log in and searching while clicking the option "Any" from search by:.....
To me the Search function is not compatible with your Language.
For this you need more knowledge than I can provide. Sorry. Keep on asking there might be others with a more satisfactory solution (Unless you want to type everything in English)
This is an encoding issue(not a language issue) likely because your database/tables are not using UTF8. Can you provide a screenshot of what you see in Administration->Database(select the openemr database and it should show the tables with encoding info for each table). Also, what openemr version is this and if you have upgraded, then what was the original version.
I tried both downloaded version and the demo...same error,...
Thanks for the report and I confirmed this on the demo. The other links for searching work except "DOB", so guessing it is related to the DATE column; I bet it will go away if we remove the LIKE(and use =) from the DOB comparison. I will look into this.
Possible fix will be using DATE_FORMAT function to left of LIKE:
Thanks for your post, you are right that the filter "DOB" Is the source of problem. but it is already using date format %y %m %d....
Log in to post a comment.