Cleanup bad text encodings within database

In rare case while doing a site migration sometimes characters like “ are replaced with â€œ. This will clean up the most common encoding issues.

wp search-replace "â€œ" "“" --all-tables --report-changed-only
wp search-replace "â€" "”" --all-tables --report-changed-only
wp search-replace "â€™" "’" --all-tables --report-changed-only
wp search-replace "â€˜" "‘" --all-tables --report-changed-only
wp search-replace "â€”" "–" --all-tables --report-changed-only
wp search-replace "â€“" "—" --all-tables --report-changed-only
wp search-replace "â€¢" "-" --all-tables --report-changed-only
wp search-replace "â€¦" "…" --all-tables --report-changed-only

Run it across a fleet

Open the console in CaptainCore Manager, pick the target sites, choose this recipe from the Cookbook picker and press run. The CLI streams each site's output back to the dock.

About the console →

More recipes