If you want to allow null values in a column:
Attribute-based schema – allows nulls by default; the default is use="optional"
, so the column below is nullable.
<xsd:attribute name="nullableColumn" type="xsd:string"/>
You make the data for this column null by omitting any specific value for it from the XML.
Element-based schema – disallows nulls by default; the default is nillable="false"
, so you must add nillable="true"
.
<xsd:element name="nullableColumn" type="xsd:string" nillable="true"/> |
You make the data for this column null by using xsi:nil="true"
.
<nullableColumn xsi:nil="true"></nullableColumn> |
Send feedback about this page using email. | Copyright © 2008, iAnywhere Solutions, Inc. |