Upcoming change on queries using certain unicode constants with UPPER() and LOWER() in Snowflake

What is changing?

Snowflake has identified and is fixing inconsistent unicode versions in the product. Most of the Snowflake service uses unicode 10 internally; however, we have identified one portion of our service using unicode 11. We will be fixing this so that unicode 10 is consistent throughout our product. You may notice query result changes after the fix if you have queries using UPPER() or LOWER() with certain unicode constants, ex. “Select * from table where col1 = upper('?')”.

When will this change occur?

The change has already been implemented as of December 3, 2021.

1