Page 1 of 1

KeyData looks same in DB and File but Lookup/Join failing

Posted: Mon May 26, 2008 7:22 am
by vinodn
Hi,
We are dealing with multi country data,these records are getting loaded from Oracle into Oracle tables and when we are taking lookup/join of one table with another which has exactly same data but loaded from some other table lookup is failing.
NLS is defined @project level is-ISO-8859-1

Plz suggest !!!!
Thanks

Posted: Mon May 26, 2008 7:32 am
by ArndW
Can you give a specific example of a key that doesn't work? Does it contain characters that are not part of Latin-1? What is your Oracle database using for NLS?