Illegal mix of collations(both table has same COLLATE) - MySQL

Databases
1

Hello All,

I have a following stored procedure


DELIMITER $$

DROP PROCEDURE IF EXISTS `myproc_t1` $$
CREATE DEFINER=`shuchi`@`10.10.10.117` PROCEDURE `myproc_t1`()
BEGIN

DECLARE done INT DEFAULT 0; 
declare temp1 varchar(20);
declare temp2 varchar(20);
declare p_id varchar(20);
declare parent_id varchar(20);
declare temp3 varchar(100);


DECLARE curs1 CURSOR FOR select product_Id from Product_Category_Member;
DECLARE curs2 CURSOR FOR select product_Category_Id from Product_Category_Member;

DECLARE CONTINUE HANDLER FOR SQLSTATE '02000' SET done = 1;

OPEN curs1;
OPEN curs2;

REPEAT
FETCH curs1 INTO p_id;
FETCH curs2 INTO parent_id;

IF NOT done THEN

select product_Category_Id into temp1 from Product_Category_Member where product_Id = p_id and product_Category_Id = parent_id;
select b.primary_Parent_Category_Id into temp2 from Product_Category_Member a, Product_Category b where a.product_Id = p_id and a.product_Category_Id = parent_id and a.product_Category_Id = b.primary_Parent_Category_Id;

SET temp3 = concat(temp1, '>' , temp2);


IF temp1 is not NULL THEN

select primary_Parent_Category_Id into temp1 from Product_Category where product_Category_Id = temp2;
set temp3 = concat(temp3 , '>' , temp1);
set temp2 = temp1;

END IF;


SELECT temp3;

INSERT INTO result select product_Id, temp3 from Product_Category_Member where product_Id = p_id and product_Category_Id = parent_id;

/*FETCH curs1 INTO p_id;
FETCH curs2 INTO parent_id;*/

END IF;
UNTIL done END REPEAT;  --  for while

CLOSE curs1;
CLOSE curs2;

SELECT * FROM result;

END $$

DELIMITER ;

When I try to execute the procedure using CALL myproc_t1(), I get following ERROR message

ERROR****
Illegal mix of collations (latin1_general_cs,IMPLICIT) and (latin1_swedish_ci,IMPLICIT) for operation ‘=’

Also When I do show create table PRODUCT_CATEGORY_MEMBER and show create table PRODUCT_CATEGORY for both I get ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_cs’

I dont see anywhere latin1_swedish_ci for any table.

Does anybody have idea why I am still getting this error?

I really appreciate the help. Thank you.
Su-

2

Check the collation of the fields in the tables, perhaps there’s a field that has latin1_swedish_ci?

What’s the collation of the database itself?