Search
Other DB Replacer questions
Forum

UTF8 characters in replace

Kovacs Peter's Avatar 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?
Kovacs Peter's Avatar Kovacs Peter
Confidential information:
(hidden)
Peter van Westen's Avatar Peter van Westen ADMIN
What happens when you select or deselect the utf8 setting?
Please post a rating at the Joomla! Extensions Directory
You can only post on the extension support forum if you have an active subscription and you log in

Buy a Pro subscription