Garrett Posted April 13, 2009 Share Posted April 13, 2009 I get this error when inserting a string that has a letter with an accent over it into my mysql db. Illegal mix of collations (swe7_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '=' I tried changing it to utf8_general_ci. It removes the error but it converts my entered string by removing everything except the first letter (including the letter with the accent over it). How do I fix this? Quote Link to comment https://forums.phpfreaks.com/topic/153808-illegal-mix-of-collations-help/ Share on other sites More sharing options...
fenway Posted April 14, 2009 Share Posted April 14, 2009 Why do you have mixed collations to begin with? Quote Link to comment https://forums.phpfreaks.com/topic/153808-illegal-mix-of-collations-help/#findComment-810113 Share on other sites More sharing options...
Garrett Posted April 14, 2009 Author Share Posted April 14, 2009 I'm exporting data from a game that allows players to use (almost) any characters in their names. Quote Link to comment https://forums.phpfreaks.com/topic/153808-illegal-mix-of-collations-help/#findComment-810141 Share on other sites More sharing options...
fenway Posted April 15, 2009 Share Posted April 15, 2009 And UTF-8 isn't general enough? Quote Link to comment https://forums.phpfreaks.com/topic/153808-illegal-mix-of-collations-help/#findComment-810599 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.