Hi J.R. Thanks for your response, but this did not help. If I try the same syntax on other values (not '*') I have no problem...
-----Original Message----- From: J.R. Bullington [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 27, 2006 3:22 PM To: mysql@lists.mysql.com Subject: RE: Using replace on columns containing * Part of the problem is that you have a ' ' in between your REPLACE and your (). The REPLACE function needs to have that space removed. SELECT REPLACE(deviceID,'*','.*') FROM MY_TABLE; Try that and see if it helps. J.R. -----Original Message----- From: Eitan Gur [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 27, 2006 9:07 AM To: mysql@lists.mysql.com Subject: Using replace on columns containing * 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. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
