|
Home > Archive > BizTalk Server Orchestration > October 2004 > Stange result in a SQL adapter response xml
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 |
Stange result in a SQL adapter response xml
|
|
| morgana@nospam.amerinetcentral.org 2004-10-15, 9:09 pm |
| Hello;
I have a static 2way port that sends a message containing multiple
records to a stored procedure that insert the records. I am using the
SQL adapter connected to the stored procedure.
When my resonse set returns It looks strange.
< ? x m l v e r s i o n = " 1 . 0 " e n c o d i n g = " u t f - 1
6 " ? > < S P _ C A L L _ R E S x m l n s = " h t t p : / / v e n
d o r . S c h e m a 1 " > < / S P _ C A L L _ R E S >
Those spaces between the lettes are hex value 00. It almost looks
like I'm getting a unicode result.
Has anybody else seen this? Any ideas how to get it looking normal?
Thanks
| |
|
|
Here's a response for one of the posts by some one from Microsoft...
********
If this is a flat file message you can specify encoding by setting "Code
page" property in the corresponding Flat File schema. This property is at
the schema level
********
Also, you can build a custom pipeline, where you can specify Encoding.
Shiv
"morgana@nospam.amerinetcentral.org" wrote:
> Hello;
>
> I have a static 2way port that sends a message containing multiple
> records to a stored procedure that insert the records. I am using the
> SQL adapter connected to the stored procedure.
>
> When my resonse set returns It looks strange.
>
> < ? x m l v e r s i o n = " 1 . 0 " e n c o d i n g = " u t f - 1
> 6 " ? > < S P _ C A L L _ R E S x m l n s = " h t t p : / / v e n
> d o r . S c h e m a 1 " > < / S P _ C A L L _ R E S >
>
> Those spaces between the lettes are hex value 00. It almost looks
> like I'm getting a unicode result.
>
> Has anybody else seen this? Any ideas how to get it looking normal?
>
> Thanks
>
>
|
|
|
|
|