|
-
Nov 15th, 2019, 02:58 AM
#1
Thread Starter
Addicted Member
Why Xquery is converting Vbcrlf to Vblf
<Root>
<Row>
<Col2>data</Col2>
<Col3>data1</Col3>
<Col4>data3</Col4>
<Col1>Rowid1</Col1>
</Row>
<Row>
<Col2>data</Col2>
<Col3>data2</Col3>
<Col4>data4</Col4>
<Col1>Rowid2</Col1>
</Row>
</Root>
The above xml is stored in sql server with datatype xml.
Here data3 is entered by user eg: data3 = A & vbnewline & B.
Query 1:
select column from table where [Sl_No]=7203
Result : A & vbnewline & B
Query 2:
select column.value('(/Root/Row[Rowid=''1'']/col4/text())[1]','varchar(max)') from table where [Sl_No]=7203
Result : A & vblf & B
All users use windows os.
why is xquery converting vbnewline(vbcrlf) to vblf?
Tags for this Thread
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|