Kovacs Peter
Hi,
I wanted to replace a few entries in the #__fields_values table. I selected the table and the "value" column, then filtered the table where field_id = 51.
In the search field, I entered: abcdefg.com
In the replace field, I entered: Ábcdéfg.com
As you can see, the replacement value is simply the accented version of the original one.
The search successfully finds the entries and displays both the old and new values. However, when I click "Replace," it indicates that the values have been replaced, but when I check in phpMyAdmin, I don't see any changes.
Interestingly, when I perform the replacement in two steps, I get the desired result:
abcdefg.com -> somethingelse
somethingelse -> Ábcdéfg.com
This makes me think there might be an issue related to accented characters.
Could you help me understand why this might be happening and suggest a solution?