add test to ensure ill-formed UTF-16 in nvarchar/ntext payloads is handled

[xiangjinwu]

We skipped it this time but it is better to have a test to prevent future version update to a problematic one.

Originally posted by @xiangjinwu in #25596 (comment)