Hmm, if I change the last join to use "on cast(EMTD.F_EMT_VALUE as varchar(377) character set utf8) = cast(EWR.F_EWR_TYPE as varchar(377) character set utf8)" it works (378 fails again). 377 doesn't ring a bell for me to run over some limit.
Wondering how is it working on other databases. -- Mgr. Jiří Činčura https://www.tabsoverspaces.com/ ------------------------------------------------------------------------------ Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.link/slashdot Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel