This is not a mysql problem, it is a phpmyadmin problem. You must be using 2.6.0 rc1, download 2.6.0 beta 2 and you won't have the problem any more. I have complained to them about it, but not exactly sure what they are going to do.
Donny > -----Original Message----- > From: Martin Rytz [mailto:[EMAIL PROTECTED] > Sent: Wednesday, August 18, 2004 9:35 AM > To: [EMAIL PROTECTED] > Subject: Problem with Mysql 4.1.3: Error #1267 - Illegal mix of collations > (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) > > Hi All > > I am very confused about MySQL 4.1.3. I have problems with the character > set > and the collation. Under 4.0.20 I had never such problems. > > I downloaded the beta-files from version 4.1.3b and zipped it to c:\mysql. > Then I loaded my data within a script with "load data infile" into my > tables... The point is, that all tables have now the collation > 'latin1_swedish_ci'?!!? Is this the default collation? Why does this > collation appear? Interesting is, that the meta-data (all tables in the > mysql-db) does have the 'latin1_swedish_ci' - collation too. > > The problem is now with phpmyadmin, if I make a select like > "SUBSTRING_INDEX( domain, '.', -2 ) from url_cat", the following > error-message appears: Error #1267 - Illegal mix of collations > (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE). I found out, > that if I use the following statement "select SUBSTRING_INDEX( domain, > _latin1'.', -2 ) from url_cat" it works!!!! But the Problem is, i won't > change all my old scripts from 4.0!!! I found out, that if I use mysql in > DOS, everything works without error!!! Do I have to change something in > phpmyadmin (i have version 2.6.0rc1)? > > I am very confused about it and i don't know how and which character-set > and > collation I have to choose. I live in Switzerland... Which character-set > and > collation I have to choose? Is there a 'standard' character-set/collation > I > should use? Do I have to set parameters in the my.cnf - file? > > My system runs under Windows XP with SP2. > > Thank you in advance for your help. > > Yours > Martin Rytz > DBA from Switzerland > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]