I am trying to consolidate data from 2 tables. Each contains a character field of maximum size (254). When I write:

select descr_eng ;
from activity, ld_activity ;
where descr_eng = txtEnglish

then I get the message Invalid Key Length.

If I alter the statement like so:

select descr_eng ;
from activity, ld_activity ;
where upper(substr(descr_eng,1,50)) = upper(substr(txtEnglish,1,50))

then the error does not occur however, the result set contains no records when it should contain some.

Perplexed?