The answer is: it depends. It depends on the code page of the client whether you will get the output you have shown.
However, you have 2 small issues:
(1) CHAR(13) returns a string with the number 13 encoded in it. You probably want to use the CHR() function instead.
(2) 13 is the ASCII character (so it only works if you have an ASCII client code page) for carriage return, i.e. the character that moves the cursor to the beginning of the line. If you want to move it to the beginning of the next line, you should use CHR(10).