Is this by design - compare CHAR BINARY with CHAR

[Jens Schreiber]

Hello,

I'm using 4.1.8-standard on linux and get this:

CREATE TABLE test (field1 CHAR(20) BINARY NOT NULL, field2 CHAR(20)
NOT NULL) TYPE=MyISAM;
INSERT INTO test VALUES('xxx','yyy')
SELECT * FROM test WHERE field1=field2

ERROR 1267 (HY000): Illegal mix of collations (latin1_bin,IMPLICIT)
and (latin1_swedish_ci,IMPLICIT) for operation '='

    Thanks
       Jens

-- 
Werkzeugmaschinenfabrik VOGTLAND GmbH     e-mail: [EMAIL PROTECTED]
Schenkendorfstr. 14                       phone:  ++49/3741/592-0
08525 Plauen                              fax:    ++49/3741/526 364
Germany                                   http://www.wema-vogtland.de

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]