Ticket #2775 (new defect)
SQL Server 2008 Driver appends spaces on the end of labels
|Reported by:||Chad||Owned by:||hobu|
|Component:||MapServer C Library||Version:||unspecified|
3 to 4 Spaces are being appended to the end of labels causing the labels to be shifted to the left. A work around is to add a replace function in the data statement that will allow the labels to display properly.
DATA "geom from (select geom,id,replace(label,' ',) as label from table)as foo using unique id"