Hi guys
I got a question which puzzles me...
I got 2 queries one works the other doesn't..
This one WORKS:
UPDATE `tablename` SET `tablecolumn` = REPLACE(`tablecolumn`, 'ä', 'ä');
This DOESN'T:
UPDATE `tablename` SET `tablecolumn` = REPLACE(`tablecolumn`, 'ü','ü');
They are both implemented into the same Zeos Conn and Query in the same order as shown above.
However the latter continously gives this error:
SQL Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'UPDATE `tablename` SET `tablecolumn` = REPLACE(`tablecolumn`, 'ü', ''If I test them in phpMyAdmin they work perfectly..... and I am aware of double ' around text items
Any one with an idea why ?`..... All help appreciated in advance
My solution: Splitted each of these UPDATEs into seperate SQL to be executed and they all worked as expected..... perhaps Zvoni suggestion will work as well... this is NOT tested.....