Hello.
The first impression is that you forgot to convert character columns. See: http://dev.mysql.com/doc/mysql/en/Upgrading-from-4.0.html http://dev.mysql.com/doc/mysql/en/Charset-conversion.html "V. M. Brasseur" <[EMAIL PROTECTED]> wrote: > Ever since we upgraded to 4.1.7, we've been seeing a lot of errors > similiar to this one: > > ERROR 1267 (HY000): Illegal mix of collations (utf8_general_ci,IMPLICIT) > and (latin1_swedish_ci,COERCIBLE) for operation 'locate' > > The query which generated this particular error is this: > > SELECT COUNT(*) FROM holdsplaced WHERE timestampDatePlaced <= > 20041130040000 AND INSTR( sPatronName, 'bubba' ) != 0; > > But other queries have also been kicking this error out as well. > > The server is being started with the following options (some altered to > protect the innocent): > > mysqld would have been started with the following arguments: > --basedir=/dbs/tpp/mysql-4.1 --datadir=/dbs/tpp/mysql-4.1/data > --port=<portnum> --socket=/dbs/tpp/mysql-4.1/mysql.sock > --user=<username> --log-error=/dbs/tpp/mysql-4.1/logs/ping.err > --log=/dbs/tpp/mysql-4.1/logs/ping.log --default-character-set=utf8 > > The problem, I'm sure, is that --default-character-set=utf8 option, but > I don't know much beyond that. Google searches aren't helping much with > this one. Something is out of alignment somewhere, I'm just not sure > what it is. > > Any help? > > Thanks in advance, > > --V > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
