[drupal-support] Replacing characters in all nodes

[Steven Wittens]

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