views:

16

answers:

0

This gives the correct result

select name_en,address_new,ddress2_new,unique_id  
from mumbaipropertydetails 
where mumbaipropertydetails."zone"='\\u092E\\u0928\\u092A\\u093E \\u092D\\u0935\\u0928';

but if I use like it does not

select name_en,address_new,ddress2_new,unique_id  
from mumbaipropertydetails 
where mumbaipropertydetails."zone"like '%\\u092E\\u0928\\u092A\\u093E \\u092D\\u0935\\u0928%';

Please tell me the solution... how to use like for unicode string.