0

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 '16 at 2:03
0

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

https://stackoverflow.com/a/12260863/1261575

https://stackoverflow.com/a/21061305/1261575

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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