Hello,
could someone help me to explain and resolve this error? Or maybe it is
a bug.
DROP TABLE IF EXISTS `test`.`karty`;
CREATE TABLE `test`.`karty` (
`ICO` char(12) collate latin2_czech_cs NOT NULL default '',
`CisloProvozu` char(6) collate latin2_czech_cs NOT NULL default '',
`CisPrac` char(10) collate latin2_czech_cs NOT NULL default '',
`TypKarty` smallint(6) NOT NULL default '0',
`Vyhotoveni` smallint(6) NOT NULL default '0',
`Jmeno` char(20) collate latin2_czech_cs NOT NULL default '',
`CisloProgramu` smallint(6) NOT NULL default '0',
`Embasing` char(7) collate latin2_czech_cs NOT NULL default '',
`VnitrniCislo` char(15) character set latin2 default NULL,
`Stanice` char(3) collate latin2_czech_cs NOT NULL default '',
PRIMARY KEY (`ICO`,`CisloProvozu`,`CisPrac`,`TypKarty`,`Vyhotoveni`),
UNIQUE KEY `VnitrniCislo` (`VnitrniCislo`)
) ENGINE=InnoDB DEFAULT CHARSET=latin2 COLLATE=latin2_czech_cs;
DROP TABLE IF EXISTS `test`.`karty_imp_tmp`;
CREATE TABLE `test`.`karty_imp_tmp` (
`PracJmeno` char(30) collate latin2_czech_cs NOT NULL default '',
`VnitrniCislo` char(15) collate latin2_czech_cs default NULL,
`CisPrac` char(10) collate latin2_czech_cs NOT NULL default ''
) ENGINE=MyISAM DEFAULT CHARSET=latin2 COLLATE=latin2_czech_cs;
INSERT INTO test.karty
values('000011111111','000001','0000000001',10,1,'test',0,'R00000','90000001AB12D3E','');
INSERT INTO test.karty_imp_tmp
values('test','90000001AB12D3E','0000000001');
SELECT k.*, kt.* FROM karty k JOIN karty_imp_tmp kt USING (vnitrnicislo);
returns error: Illegal mix of collations (latin2_general_ci,IMPLICIT)
and (latin2_czech_cs,IMPLICIT) for operation '='
I don't know where latin2_general_ci collation comes from.
OS WinXP, MySQL 4.1.15-nt-log
Thanks in advance
Dusan Pavlica
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]