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, 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