Facing lookup problem for Hebrew Data

[ketanshah123]

Hi

I am facing a problem in IF condition while comparing the Hebrew data.

In the Key Expression i am comparing value of input column 'MeoravStatus'

If DSLink10.MeoravStatus = '?????' Then 'Cancelled' Else 'Active'

the value is coming from inputfile is in Hebrew i.e 'מבוטל' which is showing '?????' which is in NLS of Hebrew, i am using NLS code 'ISO8859-8'.

I have tried this also, If DSLink10.MeoravStatus = 'מבוטל' Then 'Cancelled' Else 'Active'

I am using 7x version on Windows OS.

Please suggest me as its giving me false value even i am passing correct value...

[ray.wurlod]

Try using the Windows code page for Hebrew rather than the ISO one.