converting German char into english

[sajithamol]

Hi,

I have a table TABLE1 which contains a column "name" that has to be matched with the column "name" of another table TABLE2, but the problem is that column "name" of TABLE1 contains values with German characters and TABLE2 has "name" with english chars...i have to convert German characters of TABLE1.name to match with TABLE2.name..

is there any way to do this?

[debasisdas]

Since you are using German character of which i have no ideas.

You give me the logic how you compare german to English .

I will give you the logic to implement the same in Oracle.