Do you have a comment or suggestion to improve SQL Server? We’d love to hear it!

SSMS Always Encrypted wizard makes incorrect collation change for UTF8 columns

When you run the Always Encrypted wizard in SSMS 18 preview 6, and you select a column that has the collation Finnish_Swedish_100_CS_AS_SC_UTF8 and then select a deterministic encryption, there is a warning triangle in the State column. That's normal, but the pop-up text says "The collation will be changed from Finnish_Swedish_100_CS_AS_SC_UTF8 to Finnish_Swedish_100_Cs_Ac_Sc_Utf8" instead of the expected Finnish_Swedish_100_BIN2. If you don't observe this and continue, the wizard later fails, exactly with the message the collation is incorrect.

2 votes
Sign in
Check!
(thinking…)
Reset
or sign in with
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Erland Sommarskog shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

    1 comment

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
      Password icon
      Signed in as (Sign out)
      Submitting...

      Feedback and Knowledge Base