QGIS » QGIS Application

Windows XP, Spatialite database layers

I have some spatial views using group_concat, which I want to show up in QGIS as multiline labels, with each item on its own line.
So I define group_concat(a,';
')
to use a semicolon, new line combination.

The result is pretty much what I want, but with a square box at the end of each line except the last. I finally figured it out - Notepad++ (or Windows notepad too) inserts both a Carriage Return & a Line Feed when you hit enter in the editor. QGIS is using the LF to split the multiline labels correctly, but is displaying the CR as the boxed character.

There's a workaround - in Notepad++, you can view all characters, and turn on the ASCII Insertion Panel, and define the view with ONLY a LF and no CR, and then everything is great.

But it'd be nice if QGIS could recognize the CR|LF combination, since that seems to be the default for Windows' most common text editors (I can't speak to any other OS/editor combo).