Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
vargasbo
Starting Member
2 Posts |
 Posted - 2005-02-11 : 09:44:36
|
| Hello everyone,I have a xml string that I want to store in the DB as text. My problem is that sql is storing all the spaces to keep the xml format, which in turn is eatting up all the space I had allocated for the field. Is there a way around this or do I have to uses OpenXML to store it? |
|
|
vargasbo
Starting Member
2 Posts |
Posted - 2005-02-11 : 10:25:34
|
| I removed the '\r\n' that C# uses to keep the pretty xml format, but I'm still getting my value truncated. |
 |
|
|
|
|
|
XML in SQL