Re: [drupal-support] Replacing characters in all nodes

Paul wrote:

Hi Gerhard, Yes, it is a rare event... but it happens as the indian languages in unicode are still undergoing some changes...

I didn't fully follow your solution. How do i run a search and replace in sql dump? Is it possible to open it in vi and do a search and replace?

This is probably easiest. Perhaps someone has made a simple conversion tool already for these particular changes. In that case, just do a mysqldump, convert the .mysql file, and import it into a fresh database. Make sure to take a backup of the unmodified dump in case anything goes wrong ;).

Steven Wittens