Hi All,

A piece of XML is stored in sql server; retrieved; different UI fields are 
filled with appropriate data by fetching data from xml which is stored in sql.

Usually the UI fields after modification are processed; stored in 
xmldocument variable; eventually stored in db.

Now one of the UI fields has double quote in the text that it contains. 

Now my question is in our development environment , the above mentioned 
attribute is replaced with " in the xml document saved to db. But in another 
environment it is saved as " itself which is causing problems. When the users 
try to open the record next time it throws xml exception.

What is the problem? xml parser? or .net or something else?

recently we switched from 1.1 to 2.0.

Please throw some light on this issue.

Thanks.

msdnuser wrote:

> Hi All,
> 
> A piece of XML is stored in sql server; retrieved; different UI fields are 
> filled with appropriate data by fetching data from xml which is stored in sql.
> 
> Usually the UI fields after modification are processed; stored in 
> xmldocument variable; eventually stored in db.
> 
> Now one of the UI fields has double quote in the text that it contains. 
> 
> Now my question is in our development environment , the above mentioned 
> attribute is replaced with " in the xml document saved to db. But in another 
> environment it is saved as " itself which is causing problems.


I fail to see the difference between " and ".


> When the users 
> try to open the record next time it throws xml exception.
> 
> What is the problem? xml parser? or .net or something else?
> 
> recently we switched from 1.1 to 2.0.
> 
> Please throw some light on this issue.
> 
> Thanks.



-- 
Göran Andersson
_____
http://www.guffa.com

The first double quote that I have mentioned in my message is """. 

"Göran Andersson" wrote:


> msdnuser wrote:
> > Hi All,
> > 
> > A piece of XML is stored in sql server; retrieved; different UI fields are 
> > filled with appropriate data by fetching data from xml which is stored in sql.
> > 
> > Usually the UI fields after modification are processed; stored in 
> > xmldocument variable; eventually stored in db.
> > 
> > Now one of the UI fields has double quote in the text that it contains. 
> > 
> > Now my question is in our development environment , the above mentioned 
> > attribute is replaced with " in the xml document saved to db. But in another 
> > environment it is saved as " itself which is causing problems.
> 
> I fail to see the difference between " and ".
> 
> > When the users 
> > try to open the record next time it throws xml exception.
> > 
> > What is the problem? xml parser? or .net or something else?
> > 
> > recently we switched from 1.1 to 2.0.
> > 
> > Please throw some light on this issue.
> > 
> > Thanks.
> 
> 
> -- 
> Göran Andersson
> _____
> http://www.guffa.com
> 

Sorry it again converts it to just double quotes. What I am trying to say is 

that in my dev environment double quote is stored as "ampersand double quote 
semicolon". But in other environments its stored as double quote itself.

"msdnuser" wrote:


> The first double quote that I have mentioned in my message is """. 
> 
> "Göran Andersson" wrote:
> 
> > msdnuser wrote:
> > > Hi All,
> > > 
> > > A piece of XML is stored in sql server; retrieved; different UI fields are 
> > > filled with appropriate data by fetching data from xml which is stored in sql.
> > > 
> > > Usually the UI fields after modification are processed; stored in 
> > > xmldocument variable; eventually stored in db.
> > > 
> > > Now one of the UI fields has double quote in the text that it contains. 
> > > 
> > > Now my question is in our development environment , the above mentioned 
> > > attribute is replaced with " in the xml document saved to db. But in another 
> > > environment it is saved as " itself which is causing problems.
> > 
> > I fail to see the difference between " and ".
> > 
> > > When the users 
> > > try to open the record next time it throws xml exception.
> > > 
> > > What is the problem? xml parser? or .net or something else?
> > > 
> > > recently we switched from 1.1 to 2.0.
> > > 
> > > Please throw some light on this issue.
> > > 
> > > Thanks.
> > 
> > 
> > -- 
> > Göran Andersson
> > _____
> > http://www.guffa.com
> > 

msdnuser wrote:

> Sorry it again converts it to just double quotes.


The term "double quote" is a bit misleading. A quotation mark is ", so a 
double quote would be "". The ' character is apostrophe, so " would 
rather be "double apostrophe" than "double quote".

(Strictly speaking, " is the character for the inch unit, and ' is the 
character for feet unit, but they are used instead of the quotation mark 
and apostrophe, as they are not available on a standard keyboard.)


> What I am trying to say is 
> 
> that in my dev environment double quote is stored as "ampersand double quote 
> semicolon". But in other environments its stored as double quote itself.


Neither is correct in an xml document. A quotation mark in a value 
should be encoded as " ( & q u o t ; ).

If quotation marks are improperly encoded or not encoded at all, the xml 
is invalid, and it's likely that it's impossible to parse it using 
normal methods.

-- 
Göran Andersson
_____
http://www.guffa.com