I have a custom SQL query that includes this field:

group_concat(distinct t.rooms, chr(10))

it's an aggregate that concatenates strings with a newline. when i display this query in a DataRegion, it renders right. on my local machine (sqlserver, tomcat6, running build from onprc12.3 branch), when I query it using the JS API, the value contains the newline character.

however, when I run this on our production server (sqlserver, tomcat6, linux box, identical build), there is no newline character in the response from the JS API. Rendering in a DataRegion looks fine. It appears that something involving the generation of the JSON, or delivering it to the browser, is eliminating that newline.

can anyone suggest any troubleshooting steps? thanks in advance.