Skip to Content
Apr 04, 2011 at 12:59 PM

space issues in the query result



I would like to fetch some data from the database using SQL Query. The query retuns some data including spaces. When I print the result of the query in xml format I am not able to see the spaces over there. It is getting trimmed. Instead of space if I use any other character the query is returning it properly. I can convert this character to space again in my transaction using string replace method. But this will be time consuming. Is there any way in MII where my query can return data including space also.

Please let me know if you have any idea about this

Thanks in advance