|
Home > Archive > BizTalk Server General > October 2005 > SQL adapter returning special characters in output
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
SQL adapter returning special characters in output
|
|
|
| Hi
I'm using SQL Receive adapter; I've got a stored procedure which
returns me a column value from database. this column has xml files
stored in it;When adapter calls this Stored proc to retrive the data i
don't get brackets in the xml
e.g
while data is like <GPF> i get <GPF>
how can I get the encoded xml?
Thanks
Vishy
| |
| carlos 2005-10-04, 7:57 am |
|
hi vishy..
this result is by default of SQL Server when you use the "for xml"
statement.... some special characters are automatically coded to its
equivalent, for example > ">", < "<", & "&"
if you want to "encoded" this value, you can override a new pipeline that
"encoded" these special characters before your orchestration take the
message.....
"Vishy" wrote:
> Hi
>
> I'm using SQL Receive adapter; I've got a stored procedure which
> returns me a column value from database. this column has xml files
> stored in it;When adapter calls this Stored proc to retrive the data i
> don't get brackets in the xml
> e.g
> while data is like <GPF> i get <GPF>
> how can I get the encoded xml?
>
> Thanks
>
> Vishy
>
>
| |
|
| Thanks Carlos for reply
Actualy values i'm getting are
< for <
> For >
" for "
etc. is there a way to set these values back to <,> or " instead of
ascii equivalents in pipeline?
Vishy
|
|
|
|
|