"Jose" <Jose@discussions.microsoft.com> wrote in message
news:E16A3A57-DBEB-4EB3-A839-7821A1D8922E@microsoft.com...
> Hi,
> I have a multiline column which write from xml send by ntext parameter,
> problem is in lines separatror, because carriage return char -CHAR(13)- is
> omitted, only line feed char(10) is witten. Column is show like this:
> Text♫Another Text...
> I had use enconding uft-16, utf-8 but neither works.
> Why happens this? Any solution?.
> Regards and Thanks.

"John Bell" wrote:

> Hi
>
> From:
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/xmlsdk/html/59fa28d7-85f9-4f61-9216-d01ad999b8c5.asp
>
> "XML processors treat the character sequence Carriage Return-Line Feed
> (CRLF) like single CR or LF characters. All are reported as a single LF
> character. Applications can save documents using the appropriate line-ending
> convention."
>
> Therefore this should not be a problem!
>
> John
>
> "Jose" wrote:
>
> > Hi,
> > I have a multiline column which write from xml send by ntext parameter,
> > problem is in lines separatror, because carriage return char -CHAR(13)- is
> > omitted, only line feed char(10) is witten. Column is show like this:
> > Text♫Another Text...
> > I had use enconding uft-16, utf-8 but neither works.
> > Why happens this? Any solution?.