2.2.5.1 sqlCompareOptionsList

This common simple type is used to specify the set of string value comparison options that are associated with a string parameter or result data column. The following XML namespace is used throughout this section:

xmlns:sqltypes="http://schemas.microsoft.com/sqlserver/2004/sqltypes"

Referenced by the sqlCompareOptions attribute within the ArrayOfSqlParameter complex type, the sqlCompareOptionsList type is defined under the "http://schemas.microsoft.com/sqlserver/2004/sqltypes" namespace as the following.

 <xsd:simpleType name="sqlCompareOptionsList">
   <xsd:list itemType="sqltypes:sqlCompareOptionsEnum" />
 </xsd:simpleType>
            
 <xsd:simpleType name="sqlCompareOptionsEnum">
   <xsd:restriction base="xsd:string">
     <xsd:enumeration value="Default" />
     <xsd:enumeration value="None" />
     <xsd:enumeration value="IgnoreCase" />
     <xsd:enumeration value="IgnoreNonSpace" />
     <xsd:enumeration value="IgnoreKanaType" />
     <xsd:enumeration value="IgnoreWidth" />
     <xsd:enumeration value="BinarySort" />
     <xsd:enumeration value="BinarySort2" />
   </xsd:restriction>
 </xsd:simpleType>

The sqlCompareOptionsList simple type is a list of values that are defined by the sqlCompareOptionsEnum simple enumeration type. Each compare option tells the server how string comparisons are to be evaluated when using Windows collations. The supported values are listed in the following table.<3>

Value	Meaning
Default	Use the database default string comparison settings.
None	Case-sensitive, accent-sensitive, kana-sensitive, width-sensitive.
IgnoreCase IgnoreNonSpace IgnoreKanaType IgnoreWidth	Case-insensitive, accent-insensitive, kana-insensitive, width-insensitive.
IgnoreCase IgnoreNonSpace IgnoreWidth	Case-insensitive, accent-insensitive, kana-sensitive, width-insensitive.
IgnoreCase IgnoreNonSpace	Case-insensitive, accent-insensitive, kana-sensitive, width-sensitive.
IgnoreCase IgnoreNonSpace IgnoreKanaType	Case-insensitive, accent-insensitive, kana-insensitive, width-sensitive.
IgnoreCase IgnoreKanaType IgnoreWidth	Case-insensitive, accent-sensitive, kana-insensitive, width-insensitive.
IgnoreCase IgnoreWidth	Case-insensitive, accent-sensitive, kana-sensitive, width-insensitive.
IgnoreCase	Case-insensitive, accent-sensitive, kana-sensitive, width-sensitive.
IgnoreCase IgnoreKanaType	Case-insensitive, accent-sensitive, kana-insensitive, width-sensitive.
IgnoreNonSpace IgnoreKanaType IgnoreWidth	Case-sensitive, accent-insensitive, kana-insensitive, width-insensitive.
IgnoreNonSpace IgnoreWidth	Case-sensitive, accent-insensitive, kana-sensitive, width-insensitive.
IgnoreNonSpace	Case-sensitive, accent-insensitive, kana-sensitive, width-sensitive.
IgnoreNonSpace IgnoreKanaType	Case-sensitive, accent-insensitive, kana-insensitive, width-sensitive.
IgnoreKanaType IgnoreWidth	Case-sensitive, accent-sensitive, kana-insensitive, width-insensitive.
IgnoreWidth	Case-sensitive, accent-sensitive, kana-sensitive, width-insensitive.
IgnoreKanaType	Case-sensitive, accent-sensitive, kana-insensitive, width-sensitive.