How to made phonotic search in SQL

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 - General » How to made phonotic search in SQL

How to made phonotic search in SQL

Rate Topic

Display Mode

Topic Options

Author

Message

amitsingh308

Posted Friday, September 14, 2012 6:07 AM

Valued Member

Group: General Forum Members
Last Login: Tuesday, April 09, 2013 5:55 AM
Points: 57, Visits: 177

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.

Post #1359200

Brandie Tarvin

Posted Friday, September 14, 2012 6:32 AM

SSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 12:39 PM
Points: 6,668, Visits: 5,695

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 Administrator, MCDBA, MCSA

Webpage: http://www.BrandieTarvin.net
LiveJournal Blog: http://brandietarvin.livejournal.com/
On LinkedIn!, Google+, and Twitter.

Freelance Writer: Shadowrun
Latchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

Post #1359218

amitsingh308

Posted Saturday, September 15, 2012 2:48 AM

Valued Member

Group: General Forum Members
Last Login: Tuesday, April 09, 2013 5:55 AM
Points: 57, Visits: 177

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.

Post #1359790

Brandie Tarvin

Posted Monday, September 17, 2012 4:39 AM

SSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 12:39 PM
Points: 6,668, Visits: 5,695

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 Administrator, MCDBA, MCSA

Webpage: http://www.BrandieTarvin.net
LiveJournal Blog: http://brandietarvin.livejournal.com/
On LinkedIn!, Google+, and Twitter.

Freelance Writer: Shadowrun
Latchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

Post #1360088

« Prev Topic | Next Topic »

Permissions