The following error is being encountered when an update query is executed.
Error Number: 22005
[Microsoft][ODBC Driver 13 for SQL Server][SQL Server]Operand type clash: varchar is incompatible with varchar(8000) encrypted with (encryption_type = 'DETERMINISTIC', encryption_algorithm_name = 'AEAD_AES_256_CBC_HMAC_SHA_256', column_encryption_key_name = 'CEK_Auto1', column_encryption_key_database_name = 'Surf_927') collation_name = 'Latin1_General_BIN2'
UPDATE tblData SET [CREDIT CARD NO] = '5353' WHERE ClientID = '31341'
The problem is related to how the query is written and using an Always Encrypted Certificate.
The environment is:
IIS 8 webserver
SQL Express 14
Windows Server 2012 R2
An ALWAYS ENCRYPTED certificate is being used on the column 'CREDIT CARD NO' and this is what is causing the problem.
The certificate is installed and configured correctly as decryption on a SELECT is fine.
Codeigniter framework is used in the PHP project and ACTIVE Record is used.
I have an idea of what needs to be done to resolve this, but I cannot do it personally. So to be selected for this you will need to explain to me what is causing the problem - this way I know you can fix the problem. Hint: its to do with Parametized
Please no cut and paste of links to your work or just saying you can fix this without demonstrating you have the knowledge.
Bu iş için 36 freelancer ortalamada $152 teklif veriyor
Hello there, I have gone through with your requirement and I can fix it with perfection. ##Let me know the site URL ? Kindly check PMB Thanks Afsana
Hello there, Greeting of the day. I can explain this in chat window. Please allow me i will let you know what is the solution of this error please come in chat window Thanks Regards
Hi, I am wordpress,PHP programmer having 5 years of experience. I am very good in wordpress,php,mysql,joomla. Recently done these projects [login to view URL]
Hello sir I hope you are doing well. After reading your offer, this looks like a perfect fit for my skill sets so May I discuss with you for further details about this project?
Hi Thanks for you good job posting. I read your description carefully and understood. As an web expert. i have strong skills and experiences in web development for 7 years. So i can do your project perfectly and al Daha Fazla
Michael Leboeuf said, “A satisfied customer is the best business strategy of all”. We very well follow it. Our main goal is to provide you 100% service and extra 50% one. Our specialist is focus on web design & fro Daha Fazla