I have a external table from synapse serverless pool (serverlesstable1) and also I have another table in sparkdb (sparktable)
when I join these two tables serverlesstable1 inner join sparktable . and it tells me collation mismatch
Latin1_General_100_BIN2_UTF8 <<< this should be the spark database collation
SQL_Latin1_General_CP1_CI_AS <<< this should be the serverless database collation
how to deal with it ?