SMF 2.0.18 has been released! Please update. Read more.
Started by OvermindDL1, February 09, 2005, 01:40:56 AM
Quote from: [Unknown] on February 11, 2005, 02:29:45 AMI suggest you use Latin1, not UTF-8, for tables unless using PHP 5... and even if, really.-[Unknown]
Quote from: mytreo on March 01, 2005, 12:58:04 PMWhy? will using UTF-8 cause any problems? (MySQL 4.1.10)
QuoteI ask because I am also getting the "Illegal mix of collations" error on our new server - although only in the thread bookmark mod for some reason?
QuoteOur SMF DB is entirely utf-8 but the MySQL on our new machine is currently set to use Latin1, which I guess is what is causing this error. I was going to change MySQL to use utf-8 (which is how I had the old server setup) instead of making all the tables Latin1? Any advice?
QuoteBTW is there a reason why this problem seems to be cropping up with several people all at once?
Illegal mix of collations (latin1_general_ci,IMPLICIT) and (latin1_swedish_ci,IMPLICIT) for operation 'ifnull'Fil: C:\apachefriends\xampp\htdocs\antracitportal\smf\Sources\BoardIndex.phpRad: 82