[drupal-support] Replacing characters in all nodes

[Gerhard Killesreiter]

On Tue, 28 Jun 2005 paul at chintha.com wrote:

>  Recently there is a change in the malayalam unicode character encodings.

Didnt think that could happen.

>  The requirement now is to convert the characters with old encoding to the
> new encoding. How do i do a search for the old characters and replace
> with the new characters in all nodes and comments? Is it possible to do
> this in the database directly?
>
>  Any comments/ideas/code snippets are greatly appreciated.

This should be possible. When Drupal migrated to utf-8 for everything, I
did a sql dump and let recode convert the dump from latin1 to utf-8.
Worked flawlessly.
So you should find yourself a version of recode or iconv that supports
this conversion for the chane at hand. Or do search and replace on the
sql dump.

Always keep a backup of your database.

Cheers,
	Gerhard