Cannot resolve the collation conflict between "Latin1_General_100_CI_AS_SC_UTF8" and "Latin1_General_100_BIN2_UTF8" in the UNION operation After upgrading to SPARK 3.4

Question

We have upgraded the Spark pool from 3.3 to 3.4. We were having the view that was absolutely working fine in Spark pool 3.3. But after upgrading it to Spark pool 3.4 the view is throwing the error Msg 468, Level 16, State 9, Line 260

Cannot resolve the collation conflict between "Latin1_General_100_CI_AS_SC_UTF8" and "Latin1_General_100_BIN2_UTF8" in the UNION operation.

What can be the issue? Efforts to use COLLATE have not resolved the problem.