i am getting error "Illegal mix of collations"

i know either i need to change db tables to utf8 or convert user input to latin1 or ansii

so i want to know, can mysql do this automatically so i won't need to change table encoding and also no need to modify my exiting queries with COLLATE expression.

  • In some cases it can and does. Would you like to show us the specific, so we can help you?
    – Rick James
    Dec 24, 2016 at 2:03

1 Answer 1


There are good explanations why MySQL can't do it automatically:



Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.