I am trying to set up Always Encrypted option for my database.
By following the Microsoft link, I was able to do the same and also verify using SSMS.
However, I am facing a problem while using the same feature in my application.
My client application is developed in C++.
When ever I try to retrieve data from the encrypted columns, the values are not in plain text but encrypted.
I tried setting all possible flags in my connection string but nothing seems to work.
Based on this, I have two questions:
AlwaysEncrypted requires the client driver to provide the encryption key and to understand the column encryption metadata.
From C/C++ you should use ODBC for AlwaysEncrypted support. See Using Always Encrypted - ODBC Driver for SQL Server.