Filtering on values with non-english letters

[Tom26487]

Hi

When running load script,  I'm trying to filter a column that contains values in hebrew, but the query returns empty (though the hebrew values exist in the table).

for example: 

Where

product = 'מלמ'.

What can I do to make it work?

Thanks

[Channa · Accepted solution]

product = 'מלמ.'

or 

product = N'מלמ.'

or since it is product try to generate autokey and then filter on key

[Tom26487]

Hi Channa !

it worked with the "N" !!

Thank you very much !

Tom