How to made phonotic search in SQL

  • Hi,

    i want to make phonotic search in SQL Server database for that I am using Soundex('AMIT') for phonotic search its working fine. but now I have to make this search this phonetic search on the database which is maintained in Hindi e.g Soundex('अमित') but I am not abble to get setisfectory results. Can any one help me how can I make phonotic search in Hindi text data.

  • Check to make sure the Hindi collation is setup on the server on which you are doing the query.

    Other than that, I don't know what answer to give you. Soundex() is not my favorite function. It's hardly perfect, and I'm not sure what libraries it uses to pull its code translations from. It could be that it's not set up to deal with non-English languages very well. It could be you're missing a library. I'm not sure.

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • i have checked in my System and server hindi font support has been install. Can you suggest me some thing else for phonetic search. How can I make search on the basis of phonetic.

  • Let me ask this first. Have you searched the internet for possible solutions yet?

    If so, what search phrase / words did you use?

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply