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
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]