unicode string search

Answer 1

I think you have confused single and double quote in your query.

You should query like this:

select mumbaipropertydetails.taxno
  from mumbaipropertydetails
  where
    mumbaipropertydetails.zone
    =
    E'\u092A\u093F\u0902\u092A\u0930\u0940 \u0935\u093E\u0918\u0947\u0930\u0947';

1. There's no need for quoting column names, if they are lower-case. If they're mixed or upper case you have to quote them in double quotes - "
2. Strings have to be quoted in single quotes - '
3. Strings that use backslash (\) for escaping, have to use a letter E before opening single quote, like in the example above.