Using replace on columns containing *

[Eitan Gur]

Hi all

 

I have a column in a table containing strings with the '*' character. I'm 
trying to use the REPLACE command on this column:

SELECT REPLACE (deviceId, '*', '.*') FROM MY_TABLE;

 

But I get the following error:

ERROR 1270 (HY000): Illegal mix of collations (utf8_bin,IMPLICIT), 
(latin1_swedish_ci,COERCIBLE), (latin1_swedish_ci,COERCIBLE) for operation 
'replace' 

 

I use WindowsXP with MySQL version 4.1.7.

 

How can I overcome this problem?

 

Thanks.