SQL Functions for Encrypting and Decrypting Large text fields
This article discusses SQL functions for encrypting and decrypting large text fields. The author explains how to implement encryption and decryption as functions in a SQL database, which can then be called from stored procedures in Power Apps. The article provides code examples for creating the encrypt and decrypt functions, including explanations of the logic and any changes made. The author also mentions using NVARCHAR data instead of VARCHAR for larger character sets and the use of chunk sizes to control the output size. Overall, the article provides a guide for implementing encryption and decryption functions in SQL for large text fields.
Article 7m
Login now to access my digest by 365.Training
Learn how my digest works
Features
- Articles, blogs, podcasts, training, and videos
- Quick read TL;DRs for each item
- Advanced filtering to prioritize what you care about
- Quick views to isolate what you are looking for right now
- Save your favorite items
- Share your favorites
- Snooze items you want to revisit when you have more time