So I was recently involved in an issue where a particular Unicode string was causing some problems in an application. The string was coming from a production database. I was asked to help reproduce this. It boiled down to this:
Can you write a SQL Script which produces a string containing every possible unicode character?
declare @allNCHARS nvarchar(max); /* Your answer would fit here. */ UPDATE MYTABLE SET Value = @allNCHARS WHERE Id = 1;
My own answer is in the comments Maybe you can come up with something more elegant.
But it’s a handy string. If you’re in QA, it can help exercise a lot of different text issues (code pages, encodings, conversions etc…).
In my own case, the string actually helped me. I was able to reproduce the issue on a local developer machine. A colleague of mine then did more detective work and squashed that bug, so it was a bit of a tag team effort there.