Geek Answers Handbook

Is an empty string valid XML?

Is a valid XML fragment? Can "insert" into an oracle xblob column or an XML column from MSSQL?

+5
source share
4 answers

Invalid xml, but it can be inserted into an XML column in SQL Server 2005. I cannot speak for Oracle, but I would almost be willing to bet that this is possible.

Obviously, with SQL Server 2005, you need to exchange a double quote for single quotes:

Insert Into MyTestTable(MyXmlColumn) Values('');

This works very well - I just tested it and the insert was successful.

+3
source

No. spec says a well-formed XML document satisfies:

document ::=  prolog  element  Misc*

Where

element ::= EmptyElemTag
              | STag content ETag
+6

XML- - . ( XML , UTF-8, 1.0 - 22 XML). XML - node, .

, " XML" .

+3

xml. xml xml node. , Oracle SQL Server, , .

+1

More articles:


All Articles