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

vinodn · Post by **vinodn** » Mon May 26, 2008 7:22 am

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

ArndW · Post by **ArndW** » Mon May 26, 2008 7:32 am

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?