Can any one provide me a SOUNDEX like SQL function working correctly for INDIAN NAMES?

i need to search indian names from my database (mysql). i tried SOUNDEX function but it fails for long india开发者_如何转开发n names.

I would suggest using the Double Metaphone algorithm for MySQL in this instance. Double Metaphone is designed to handle the difficulties associated with words from different root languages. It is based upon Metaphone, which was designed to correct some of the deficiencies of Soundex. Here is a link to the Double Metaphone site where you can learn more about it and also see examples in multiple languages including MySQL:

http://www.atomodo.com/code/double-metaphone