Untitled

the procedure:
**************

DELIMITER $$

DROP PROCEDURE IF EXISTS `prepaga`.`p1`$$

CREATE DEFINER=`root`@`localhost` PROCEDURE `p1`( la varchar(20), ls varchar(20))
BEGIN
delete from b_cuit_cuil_aportes
	       	where lotes_aportes=la and lotes_subsidios=ls;
END$$

DELIMITER ;



using the procedure:


call p1('50,51' ,'111');

Error Code : 1267
Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (latin1_general_ci,IMPLICIT) for operation '='
(0 ms taken)


call p1('50,51'  COLLATE latin1_general_ci,'111'  COLLATE latin1_general_ci);

Error Code : 1267
Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (latin1_general_ci,IMPLICIT) for operation '='
(0 ms taken)



call p1('50,51'  COLLATE latin1_swedish_ci,'111'  COLLATE latin1_swedish_ci);

Error Code : 1267
Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (latin1_general_ci,IMPLICIT) for operation '='
(0 ms taken)