#382 Illegal

[Hakem Zave`]

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

[Hakem Zave`]

second attachment

[Pieter W]

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)

[Hakem Zave`]

Yes, it happens even the used language is same for both log in and searching while clicking the option "Any" from search by:.....

[Hakem Zave`]

detailed

[Pieter W]

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)

[Brady Miller]

Hi,

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.

-brady
OpenEMR

[Hakem Zave`]

Hello, Brady..
I tried both downloaded version and the demo...same error,...

[Brady Miller]

Hi Hakem,

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.

thanks,
-brady
OpenEMR

[Brady Miller]

Possible fix will be using DATE_FORMAT function to left of LIKE:
http://stackoverflow.com/questions/11899547/illegal-mix-of-collations-while-comparing-datetime-with-string

[Hakem Zave`]

Hi, Brady,
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....