php mysql替换中的英镑符号问题

Question

I am replacing characters in my mysql database and while I can replace chacters such as $ or ~ for some I can't get it to replace the following symbol £. Why?

$sql[$handle]['sql'] = 'UPDATE '.$table.' SET '.$field.' = REPLACE('.$field.',\''£'\',\''.$replace.'\')';

Answer 1

try replacing the '£' with CHR(156) in your replace syntax