Upvotes: 3<=-=Mar 21 2017 1:08PM=-=>
Thank you for your feedback!
We will consider this feature for the future releases of SQL Server and Azure SQL Database.
An error occurred while saving the commentAaron Hope commented
I'd love to see transparent compression of off-row data, but wouldn't a general purpose compression alg make more sense than SCSU? I just want type-safe COMPRESS/DECOMPRESS without all the repetition.
Upvotes: 2<=-=May 21 2017 3:20AM=-=>
The docs (at msdn: “Specify Field and Row Terminators (SQL Server)”) say, “Any printable character”. They do not say, “Any printable ascii character”, so the product is not currently meeting this important promise.
Although it’s well and good that the product supports “String of up to 10 printable characters”, and this could be used to specify a bullet-proof terminator signature, Excel does not support importing text files with multiple sequential delimiters, so generating files with such a sequence would not support viewing/manipulating the data in Excel. In practical terms, we end up needing to use standard qualifiers, which are ugly.
There is value to supporting non-ascii field terminators so please fulfill the promise made in the docs.