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? 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? 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. 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? 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
Archived
This topic is now archived and is closed to further replies.