"Alex Chan" <hnchan@netvigator.com> wrote in message
news:eMwUFCnjDHA.3504@TK2MSFTNGP11.phx.gbl...
> Hi All,
>
> Is it possible to store the XML stream object into SQL Server image field?
> The reason that I need to store in such way because this field may store
the
> PDf or the XML.
>
> I have also pass the XML into the stream object as text type. and use
> "WriteText" function to write it into the database but it won't allowed if
> it is the image field. But if I change it to ntext field, it works. Is
there
> anyway to store the text file through the stream to image field of SQL
> server.
>
> Thanks and Regards
> Alex
>
>

"Mark J. McGinty" <mmcginty@spamfromyou.com> wrote in message
news:ON5OLDzjDHA.2312@TK2MSFTNGP12.phx.gbl...
> Storing it should not be a challenge, just pass your XML buffer to the
Write
> method. You can even use CopyTo to copy from a text stream to a binary
> stream.
>
> Unfortunately that's a one-way ticket, because you can't use ReadText on a
> binary stream, and you can't use a text stream to access an image field.
> Since Read from a binary stream returns a byte array, you could iterate
the
> array, converting each byte to a character and concatenating an output
> buffer with each, but you'll find that to be painfully slow.
>
> The only other way is to use 2 fields, switching between tham as
appropriate
> based on content.
>
> -Mark
>
>
>
>
> "Alex Chan" <hnchan@netvigator.com> wrote in message
> news:eMwUFCnjDHA.3504@TK2MSFTNGP11.phx.gbl...
> > Hi All,
> >
> > Is it possible to store the XML stream object into SQL Server image
field?
> > The reason that I need to store in such way because this field may store
> the
> > PDf or the XML.
> >
> > I have also pass the XML into the stream object as text type. and use
> > "WriteText" function to write it into the database but it won't allowed
if
> > it is the image field. But if I change it to ntext field, it works. Is
> there
> > anyway to store the text file through the stream to image field of SQL
> > server.
> >
> > Thanks and Regards
> > Alex
> >
> >
>
>