CODEWITHSUNDEEP
snowflake-cloud-data-platform
Hannah
Hannah

Reputation: 85

Using special character to JOIN

I have a table A which loaded from a external stage, one column col1 has special char for example 'Español'. I need to join tableA with tableB

select * from tableA
join tableB
on tableA.col1 = tableB.col1

I know tableB.col1 has exactly same value 'Español', but this join couldn't catch it. Anyone knows why and how to get it joined?

Thanks.

Upvotes: 0

Views: 354

Answers (1)

cyberhiker
cyberhiker

Reputation: 71

If the join is failing it is because the values in col1 are not equivalent even though they might look the same when displayed. I wonder if using hex_encode(col1) on each table might surface the difference?

Upvotes: 1

Related Questions