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

[ Post a follow-up to this message ]

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
>
>

[ Post a follow-up to this message ]