Your application of course will need to support it, and SQL server doesn't have a native "attribute" that I know of to say that "NULLs aren't allowed, but zero-length strings are...", you could ...

After my post about Encrypting Rich Text fields in Power Apps that store their data in SQL server now the promised decryption code in this post as well.