Facing lookup problem for Hebrew Data
Posted: Fri Oct 19, 2007 4:16 am
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...
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...