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@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/ ]