Is it Possible to apply soundex function for two strings of Unicode Langaues (Eg: Kannada) In Sql

Question

0.00/5 (No votes)

See more:

SQL-Server-2008R2

Hi Experts,

I want to check that Two Unicode language strings are equal, in sql by using soundex function.
Or Is it possible to get matching Unicode strings from the database by passing one string in where condition of a sql query?
I have tried with Soundex and phonetic translation. But its not possible in that.
Can any one please give some ideas to solve this problem ?

thanks
Keerthi Kumar

Posted 11-Sep-14 19:51pm

Keerthi Kumar(Andar)

Updated 11-Sep-14 20:42pm

v8

Add a Solution

Comments

George Jonsson 12-Sep-14 1:59am

Do you mean to compare Kannada and Canada?
Different spellings of the same country in different languages?

Keerthi Kumar(Andar) 12-Sep-14 2:07am

No, I mean i want to apply soundex function in sql for two kannada names.
Kannada is a language used in south India.

George Jonsson 12-Sep-14 2:18am

Well maybe you should rephrase your question to make it more clear. :)
Don't expect people to know everything about your requirements and environment.

Sinisa Hajnal 12-Sep-14 2:11am

Kannada is a language from people far from Canada in America :)

You could compare two strings using culture.

George Jonsson 12-Sep-14 2:19am

I would say that most people in the world don't know that. :P

Keerthi Kumar(Andar) 12-Sep-14 2:22am

ya...but. I got this requirement from people those who use it.
I cant force those user's to use English.

George Jonsson 12-Sep-14 2:58am

That is understandable and why should you force people to use English?
My point though, is that in this forum most people will not know what Kannada is, so it helps if you explain this in your question.

Sinisa Hajnal 12-Sep-14 2:46am

I agree...I only know because I heard an example of the language in a course I went to. I thought how their letters look like tolkiens elven :)

But it is one of the top 40 languages in the world with over 40 million people speaking it (that is ten times more then my own language :o )

Bernhard Hiller 12-Sep-14 2:49am

Well, the question is actually: where to get a phonetic translation and comparison algorithm / library from for Kannada?
If I remember correctly, the "literal" transliteration is of that South Indian state is Karnataka, but a more phonetic transliteration is Kannada...
I do not know such a library / algorithm, perhaps you have to create it yourself. Or you could find one on an Indian programming forum (in that case: would be nice if you tell us about it here).

Keerthi Kumar(Andar) 12-Sep-14 2:56am

Hi Bernhard Hiller,
You r right, you understood my problem.
this is what am searching for.

1 solution

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Sinisa Hajnal · Answer 1 · 2014-09-11T20:12:00

Solution 1

See how to compare strings given specific culture[^]

Use New CultureInfo("kn-IN")

Posted 11-Sep-14 20:12pm

Sinisa Hajnal

Updated 11-Sep-14 20:17pm

v2

Is it Possible to apply soundex function for two strings of Unicode Langaues (Eg: Kannada) In Sql

1 solution

Solution 1

Add your solution here

Preview 0

Is it Possible to apply soundex function for two strings of Unicode Langaues (Eg: Kannada) In Sql

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us