If you force pagination by narrowing your console window to force the following output to paginate:
select 'This is a long string that will cause the output to paginate', char(0);
You'll notice that the null character in wide output shows up as an empty, zero length string, but in less it shows up as a grey '^@' which upsets the formatting of the table output (the expected display width of that character was 0).
If you force pagination by narrowing your console window to force the following output to paginate:
You'll notice that the null character in wide output shows up as an empty, zero length string, but in
less
it shows up as a grey '^@' which upsets the formatting of the table output (the expected display width of that character was 0).