Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

How to made phonotic search in SQL Expand / Collapse
Author
Message
Posted Friday, September 14, 2012 6:07 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Monday, April 21, 2014 11:55 PM
Points: 64, Visits: 205
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
Posted Friday, September 14, 2012 6:32 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 5:48 AM
Points: 7,203, Visits: 6,348
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

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
Posted Saturday, September 15, 2012 2:48 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Monday, April 21, 2014 11:55 PM
Points: 64, Visits: 205
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
Posted Monday, September 17, 2012 4:39 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 5:48 AM
Points: 7,203, Visits: 6,348
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

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 »

Add to briefcase

Permissions Expand / Collapse