it is solved...:-)

it's the problem of having different collation in column level. i just dropped the table(after taking backup of data). created again.. now it works properly..

Thanks a lot all of you....