Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
OPENXML and whitespace
Message
From
04/02/2002 10:05:26
 
 
To
All
General information
Forum:
Microsoft SQL Server
Category:
Import/Export
Title:
OPENXML and whitespace
Miscellaneous
Thread ID:
00614801
Message ID:
00614801
Views:
101
How can I force OPENXML to include all leading and trailing whitespace, and newlines that are in my xml data?

All whitespace and newlines are being removed from my xml data when I use OPENXML to import the data into the database. I am using a specific database table to map the data to datatypes in the database, as in:

Select * from OPENXML(....) WITH myTable

I am aware that there is an attribute called 'xml:space' to force whitespace to remain in the data, but since I am using the database table itself to import I don't have a DTD to add this attribute to.

Is there a way to force OPENXML to include all whitespace and newlines that exist in my xml data?

Thanks,
---Tom
Reply
Map
View

Click here to load this message in the networking platform