[drupal-support] Replacing characters in all nodes

[Paul]

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?

running recode/iconv: Is this done at the command line?

thanks for your quick response...

thanks,
Paul

Gerhard Killesreiter wrote:

>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, Idid 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 supportsthis conversion for the chane at hand. Or do search and replace on thesql dump.
>Always keep a backup of your database.
>Cheers,	Gerhard
>-- [ Drupal support list | http://lists.drupal.org/ ]
>
>
>  
>