What does i:nil="true" mean?

xml null xml-nil
dtc picture dtc · Jan 21, 2009 · Viewed 104.9k times · Source

I have an xml and it has nodes with i:nil="true" in it. What does that mean?

For example:

<FirstName i:nil="true" />

Does that mean something different than:

<FirstName />

If so, what is the difference?

Answer

Ray Lu picture Ray Lu · Jan 21, 2009

This means FirstName is null

<FirstName i:nil="true" />

This means FirstName = ""

<FirstName />

Assumption made on FirstName is of string type.

Related questions

What is the correct way to represent null XML elements?

I have seen null elements represented in several ways: The element is present with xsi:nil="true": <book> <title>Beowulf</title> <author xsi:nil="true"/> </book> The element is present, …

Read More
Selecting null value from XML in SQL Server

I'm trying to select from XML that has a null as one of the attributes. Instead of returning a null, it returns a 0. What am I doing wrong? See code below to replicate: declare @a xml select @a = '<…

Read More
How do I check if XML value is nil in XSLT

In an XML document I have some address data.. <zip>08001</zip> <zipPlus xsi:nil="true" /> and <zip>08002</zip> <zipPlus>4512</zipPlus> On only want to bother displaying …

Read More